July 4, 2013 at 3:41 am
This is a general question to see if I'm missing something obvious before I start digging in depth. I'm new to SSRS and I wouldn't necessarily know where to start digging without help.
My problem is that when I a run report in SSRS it returns one row of data but when I run the associated proc in SQL Server 2008 it returns two rows. I've run Alter Proc every time I've made a change, I've refreshed the fields on SSRS and refreshed the report every time I've run it. The parameters in the report are identical to those in proc but still I'm still only getting one row.
Is there anything else I can check to solve this? If there is any more information I can provide to make answering easier please ask and I'll post it as soon as I can.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
July 4, 2013 at 3:50 am
Make sure SSRS is not using cached data.
Go to the folder where the report is stored and delete any .DATA files.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 4, 2013 at 4:31 am
I've solved it; or rather my boss did.
There was a problem with the way I'd formatted the report, I'd deleted the header row so I was putting my fields in the wrong row. That meant it would only ever show one row. It looked alright at first glance so it took a while to spot which is why he didn't see it the first time he checked.
Thanks for your help.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
July 4, 2013 at 6:55 am
Allright, glad that you found the issue and thanks for posting back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply