Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Difference in results in SSRS from those in SQL Server Expand / Collapse
Author
Message
Posted Thursday, July 4, 2013 3:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 925, Visits: 2,962
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.



On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
Post #1470368
Posted Thursday, July 4, 2013 3:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
Make sure SSRS is not using cached data.
Go to the folder where the report is stored and delete any .DATA files.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1470373
Posted Thursday, July 4, 2013 4:31 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 925, Visits: 2,962
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.



On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
Post #1470390
Posted Thursday, July 4, 2013 6:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
Allright, glad that you found the issue and thanks for posting back.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1470431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse