SSRS Problem [modified]
-
I'm fairly new tyo SSRS, so bear with me... I created a report that is getting its data from a stored procedure. When I run the stored procesure in the data tab it is returning 68 rows, yet only 1 rows shows up on the report in preview, and, it's the last row in the dataset. If I export the data as a CSV to the desktop, there is only one row in the data. I have no clue how to debug this. Could use some help. Thanks
Everything makes sense in someone's mind
modified on Sunday, April 10, 2011 4:49 PM
-
I'm fairly new tyo SSRS, so bear with me... I created a report that is getting its data from a stored procedure. When I run the stored procesure in the data tab it is returning 68 rows, yet only 1 rows shows up on the report in preview, and, it's the last row in the dataset. If I export the data as a CSV to the desktop, there is only one row in the data. I have no clue how to debug this. Could use some help. Thanks
Everything makes sense in someone's mind
modified on Sunday, April 10, 2011 4:49 PM
I have run into this a couple of times, look for a {file name}.rdl.data file and delete it it. That contains a cached set of data for the report.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.