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