Why is my SSRS report showing old data?

reporting-services reportingservices-2005
Kon picture Kon · Aug 13, 2013 · Viewed 49.2k times · Source

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

Nagshead picture Nagshead · Aug 27, 2013

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

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base …

Read More
How to get named excel sheets while exporting from SSRS

Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in …

Read More