all groups > sql server reporting services > february 2005 >
You're in the

sql server reporting services

group:

Forced auto refresh to avoid page caching



Re: Forced auto refresh to avoid page caching Adrian M.
2/28/2005 2:16:04 PM
sql server reporting services: Try adding the rs:ClearSession=true to the report url.

--
Adrian M.
MCP

[quoted text, click to view]

Forced auto refresh to avoid page caching Jonathan Martin
2/28/2005 3:59:46 PM
Good Afternoon!

I've run into an issue whilst developing a report using VS.NET, RS and SQL
Enterprise Server 2000.

The problem I have is that I'm using RS to develop a web based app that can
be used to edit base table data. I have the app working fine, but it keeps
taking it's data from the cached reports. Obviously, this means that every
time a change is made to the base data, the user needs to refresh the page -
not an easy thing to remember when processing several hundred entries.

I have the "Do not cache temporary copies of this report" radio button
selected (by default). Also, the "Autorefresh" text box is not an option I
can take as it is unusable when there are groups set up on the table - they
keep expanding and collapsing.

I've seen ways of embedding some (rather shaky) HTML to force the refresh.
See below:

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Pragma-directive" CONTENT="no-cache">
<META HTTP-EQUIV="cache-directive" CONTENT="no-cache">

Is anyone aware of how I can write this into the .rdl, or report? Or, is
there a way to force the page to refresh?

Thanks in advance


Jon


Re: Forced auto refresh to avoid page caching Jonathan Martin
3/1/2005 11:22:02 AM
I tried it manually, and it didn't appear to change anything.

Is there a way I can embed that statement in the rdl?


Thanks

Jon


[quoted text, click to view]

AddThis Social Bookmark Button