Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Data issues with the report output

Author  Topic 

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2007-11-14 : 15:03:27
Hi,

I just successfully created my first report using sql server reporting services, I am having some issues with the report output. The report has been created against the stored proc, when I run the stored proc within query analyser I get 3 rows, whereas when I run the report I get only 1 row. I need to know how I can troubleshoot this problem. Please help. Thanks.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2007-11-14 : 15:58:01
Does the report do more than exec the sproc? Does it add a filter, pass parameters etc?





Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2007-11-15 : 10:12:11
The report does'nt have any filters, it just executes the sproc by passing in the input params to the sproc. Thx.
Go to Top of Page
   

- Advertisement -