Geek asks and answers

SSRS report not updating via URL access

I want to display SSRS report output in an IFrame of another application. I set the source like this:

http://SERVERNAME.domain.com/ReportServer?%2fTBI_MSCRM%2fCustomReports%2f%7bdafdbed0-1e96-e211-a5da-001d0967e0fc%7d&rs:Command=Render&rc:Toolbar=false

The problem I am facing is that the report output seems to be cached for the session.

If the report has a timestamp that does not refresh when the page refreshes. To view the updated data, you must close the entire browser and reopen the page. Snapshots are not included in SSRS, there is no plan to update the cache if the option "Do not cache temporary copies of this report" is selected.

I infer the URL from the IFrame and run it in isolation, and get the same results, so the IFrame problem is not a problem. I need this report to be updated every time a URL is available.

Any ideas are greatly appreciated.

+5
source share
1 answer

You can force the report server to receive a new report in each request by clearing the session.

Just add the following to the URL rs:ClearSession=true

It will be implemented in your URL as follows:

http://SERVERNAME.domain.com/ReportServer?%2fTBI_MSCRM%2fCustomReports%2f%7bdafdbed0-1e96-
e211-a5da-001d0967e0fc%7d&rs:Command=Render
&rs:ClearSession=true&rc:Toolbar=false

Clear Session:

True directs the report server to remove the report from the report. All report instances associated with the authenticated user are removed from the report session. (A report instance is defined as the same report executed several times with another report of the parameter value.) The default value is false.

see here for more information

+16
source

More articles:


All Articles