Why is my SSRS report showing old data?

Question

I have a live report that's somehow showing cached data despite the fact that I've disabled all caching (that I'm aware of). When I run the query in the BIDS query editor, it shows the current data. But in the BIDS preview and the actual deployed report, it's still showing out of date data.

I tried toggling the report caching on then back off in the report properties on the reporting website, and I went into the IIS HTTP Header properties and set content to 'Expire Immediately'. I've seen this issue before in the BIDS preview window due to the .data file stored with the report definition (which I've deleted/refreshed several times), but I've never seen it happen with a live report.

Is there another caching option somewhere that I'm missing?

Edit: The report also has a user-selected parameter, which makes this even more perplexing since I was under the impression that parameters cause SSRS to use the most recent data even when caching is enabled.

Answer 1

In development mode for SSRS, I usually delete the report_name.rdl.DATA File. That is were the data is kept from the last run.

It took a few runs to figure out that this was my issue with changing the source data and the report looking like the last run.

Edit: Beware not to delete your .rdl report file (it's the "report.rdl.data" file that you want to delete in order to refresh the resultset).

Answer 2

Old post, but I still run into this, and found an article on how to put an option under external tools to make this easier.

1. Go to Tools > External Tools...
2. Add a new tool with the following settings:
   • Title: Clear Report Data Cache
   • Command: "%WinDir%\System32\cmd.exe"
   • Arguments: /C DEL /S /Q "$(SolutionDir)\*.rdl.data"
   • Check options: Use Output window & Close on exit

Now whenever you want to delete your report data cache, just go to Tools > Clear Report Data Cache

Full article here: http://jasonfaulkner.com/ClearDataCacheBIS.aspx