Report Builder 3.0 - You must have at least one field for your dataset.
I am going thru the wizard to build a table report and when I choose an already created stored procedure and then click the next button I get the following "You must have at least one field for your dataset." Thanks
June 2nd, 2010 1:01am

Note, when populating fields RS actually only query schema (SchemaOnly in ADO.NET), which equals to SET FMTONLY ON in T-SQL. So try to execute SET FMTONLY ON before your stored procedure. Can you get the same result when it is off?Have fun with Reporting Service
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2010 11:48am

The same message box appears with Set FMTONLY ON. The actual datasource is configured for a SQL SERVER 2000, does this matter?
June 2nd, 2010 4:09pm

No, I mean to execute the query from SQL Server management studio. How many fields can you get? I was expecting a empty data set is returned.Have fun with Reporting Service
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2010 4:24pm

What I thought you meant wat inside the Stored Proc to add the Set FMTONLY ON. When I did that it gave me an empty dataset. So then I tried the RS wizard again and it gave me the same message. The sp is building a temp table doing some calculations on the data and then displaying the temp table.
June 2nd, 2010 6:21pm

Set FMTONLY ON is not to fix your problem. I just want you know the internal behavior of RS. If RS can't get schema from yoru SP, the message box will pop up. You should fix your SP to make sure data set with 0 row is returned rather nothing. Have fun with Reporting Service
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2010 6:50pm

Thanks, you are correct. The stored proc has to return an empty data line when the parameters are left bank.
June 2nd, 2010 10:07pm

HI Qiao, Firstly, I need to know what do you mean for SP. Then kindly tell me how to add Set FMTONLY ON/OFF, either add in RB 3.0 or SQL Mangement Studio. Thanks in advance Regards Ahsan
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2013 12:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics