Thursday, March 8, 2012

Data Caching in reports?

I wrote an invoice report that gets its data from an Oracle database. This is working fine except when users change something on the server (like adding a new charge to the invoice) then when they re-run the SSRS report the new line doesn't show up. They wait 15 minutes and re-run the SSRS report and then it appears.

It is like the SSRS report is caching the old data of the report.

Points to note though...

To execute the report I am using the SSRS 2005 webservice. I understand that there is 2 cachings, 1 server and 1 IIS side. I have not cached the server and don't know how to clear the IIS side. I see there is a rs:ClearSession=true parameter that you can pass in but by using the SSRS 2005 webservice this is not an option (I don't see how you can pass query strings in to the call).

Does SSRS cache the Oracle DataSet at all?

Thanks heaps for any help,

Craig

I'm having issues with caching too, but it may be a different problem than yours. Check the settings on your report server to make sure it is set to not caching.

Under the Properties tab, execution left menu there is a "Render this report with the most recent Data" radio button. Make sure the "Do not cache temporary copies of this report" radio button is checked.

No comments:

Post a Comment