Report data not matching DataSet data
I have a matrix report that I am designing in SSRS 2005. When I run the query in the data tab, it runs fine and I see the data that I would expect (November data). When I run the report, it gives me data for October.
I am not using parameters in this report. I have checked for filters and do not see any.
Where should I be looking for the disconnect? I know I am not giving a lot of details. If anyone wants to help and needs more, just let me know what else I should disclose.
Thanks,
Wayne
December 28th, 2010 4:13pm
Try deleting the *.rdl.data file. There might be caching going on.
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 4:18pm
Thank you so much. That did the trick!
December 28th, 2010 4:30pm
There's a cool add-in on Codeplex for this if you use BIDS.
http://bidshelper.codeplex.com/wikipage?title=Delete%20Dataset%20Cache%20Files
Cheers!
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 4:42pm