December 15, 2011 at 1:20 pm
Hi all,
I have an ASP.NET application that runs several reports based on Reporting Services 2000.
It seems that when I run a report, change the data on the database, close the report and reopen it, this does not shows new values from database, like if it has some kind of memory of the first run.
Anyone can help me to understand this strange behaviour?
Thanks in advance.
Luigi
December 16, 2011 at 2:58 am
That is probably because of the cache. It makes your reports run faster if they are called multiple times in a row, but it can give problems if the data is refreshed.
See this link for more information:
http://msdn.microsoft.com/en-us/library/aa274392(v=sql.80).aspx
ps: we're almost 2012 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 16, 2011 at 8:22 am
Thank you Koen, I'll try to disable the cache.
Luigi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply