Data will not show on report preview

Data will not show on report preview

Post by ZGFyd2l » Wed, 23 Feb 2005 01:39:09


I have a proc that combines the results from 2 queries. I can see all of the
data in QA and the Data tab of SRS there are no issues with that part. When
I preview the report only the second part shows up, nothing from the first
query. I have started over a few times, still the same problem. Any ideas??
Thanks
 
 
 

Data will not show on report preview

Post by Bruce L-C » Wed, 23 Feb 2005 02:33:47

Make sure your SP returns only one resultset. RS does not handle multiple
resultsets. I.e. you should only have one select statement. If you have
multiple it will only use the first one.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services




the
When
ideas??

 
 
 

Data will not show on report preview

Post by ZGFyd2l » Wed, 23 Feb 2005 02:49:02

There is only one select statement, it joins 2 temp tables. The record set
looks fine in SRS Data tab and in QA, just not in the actual report.
 
 
 

Data will not show on report preview

Post by Brian Welc » Wed, 23 Feb 2005 03:40:43

Try it using the generic query designer in the data tab. The code used there
is exactly what is used during report preview time.

--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
 
 
 

Data will not show on report preview

Post by Bruce L-C » Wed, 23 Feb 2005 05:09:28

This should work. One thing to make sure of with your SP is that you do not
explicitly drop your temp tables. Just let them fall out of scope. Also,
have your select be the last statement.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
 
 
 

Data will not show on report preview

Post by ZGFyd2l » Wed, 23 Feb 2005 06:41:06

I started all over again, this time I created the parameter dataset first
then added the call to the stored proc. This worked, no clue as to why.. as
to the temp tables I have always droped them after the last select with no
issues.
thanks all ;)
 
 
 

Data will not show on report preview

Post by VGllbiBUcm » Sun, 20 Mar 2005 04:27:03

This is exactly the problem I am having that SProc only use the first select
query even though the parameter passed to it is wrong.
To fix this, I have to write a seperate SProc which does not make sense
since we can use 1 SProc to return a correct dataset from select query based
on parameter(s) pass to it
I wonder if this bug will be fixed in Service Pack 2