Data Missing From Report Preview
-
Hello,
I have written a parameterised Stored Procedure which links to and displays data beautifully in the DataSet preview area.
The problem is that when I try to preview the Report (with the same parameters) it doesn't return any data.
Having reviewed the other threads on this forum I have tried the following:
1) Added all of the following to my stored procecure:
SET
NOCOUNT ON, SET FMTONLY OFF; SET NO_BROWSETABLE OFF
2) Restructured the procedure so that (instead of creating a temporary table and carrying out a series of updates on it - which ran much faster) it now builds one monster unionised (shudder) subqueried query as the only output.
As well as directing much angst and frustration at it - none of this seems to work.
Does anyone else have any suggestions?
....Please???
Helen
-
SP's in RS can use temp tables as I do this all the time when developing reports. It sounds like your SP is not receiving the parameter values correctly. To verify this, I'd try setting up the procedure to not use a]the parameters and then preview the report.
Does the report now return data?
Dave
-
Are you using mulitple values ?
There are problems passing this to a stored procedure.
Been looking long for an answer about this issue.
JV -
Eureka!!
I commented out the parameters and the data Previewed beautifully - the data is still rubbish but at least I can see my rubbish data!!!
I've since deleted and recreated the DataSet SP connection and all of the Parameters. It works fine now - I'm thinking that I must have named something badly somewhere.
Thank you so much for the suggestion - it's saved me from going around in a pointless loop!
Helen
-
Hello,
No I'm not using multiple values for this one but I do know what you mean.
I'd be interested in seeing how you resolve it if you find a way!
Helen
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply