Getting a cached report on subsequent previews -- sql server reporting services

sql server reporting services : Getting a cached report on subsequent previews

adrianM
10/18/2004 4:47:53 PM

I have and application that creates and publishes reports to the Reporting
server. I allow the user to preview the report. If the user creates a
report named 'Test Report', for example, and preview it the first time - all
is fine. If the user makes small changes to the report (say reordering the
ORDER BY in the SQL statement) and keeps the same report name, then
publishes and previews, the report reflecting the latest changes isn't
displayed. The first report is displayed. The user has to hit the refresh
button on the reporting toolbar to get the recently updated report. It's
like I'm getting a cached report because the changes to the report where
minimal. Any way to get around this??

Thx
Adrian

PeteZ
10/19/2004 8:24:38 AM

Adrian,

I believe there are caching option settings in the System Settings page. You
may want to review this to see if there is an option to fix your issue.

- peteZ

[quoted text, click to view]

adrianM
10/20/2004 4:00:20 PM

For the benefit of the group, in order to avoid the issue mentioned in my
original post you have to add the [rs:ClearSession=true] to the URL.

Adrian

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn