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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics