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.
Best Answer
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).