all groups > sql server reporting services > october 2006 >
You're in the

sql server reporting services

group:

Reporting services caching data !!!


Reporting services caching data !!! fitim skenderi
10/20/2006 3:53:07 PM
sql server reporting services: Hi all,

I have a smart client application that hosts an instance of IE. After user
selects different seetings (parameters) create a URL and ask the IE to
navigate to it. First time I get proper data.
The problem starts when user clicks on the button to view the same report
with same parameters - the data is retreived from cache. I have configured
the report not to use cache (the option 'Do not cache temporary copies of
this report' through Report Manager), I also have a command on my URL
specifying to reset the session timeout (rs:Command=ResetSessionTimeout),
but I still get the data from the cache.

Just to be sure I have even dropped the stored procedure that is used to
populate the report, and data still comes.

Only when I close the instance of my application and start it again, I get
the right data. From what I gather I think that somehow either IE or ASP.NET
2.0 is caching the data.

If anybody has any ideas please respond. Desperately need to fix this.

Thanks very much


Re: Reporting services caching data !!! Immy
10/20/2006 4:23:25 PM
I'm not a developer - but i had this problem when I first deployed reporting
services in my business.
The developer at the time appended 'ClearSession=true' to the Url and it
worked.
You can try that?

Immy

[quoted text, click to view]

Re: Reporting services caching data !!! fitim skenderi
10/20/2006 5:54:52 PM
Thanks very much for the response. Unfortunately it is still caching. The
weird thing is it does not cache on RS2000 only on RS2005. And I think the
ReportViewer.aspx is doing the caching, because it does not go to a database
at all.

thanks anyway




[quoted text, click to view]

AddThis Social Bookmark Button