SQL Server Performance

Caching problem in sql reporting services.

Discussion in 'SQL Server Reporting Services' started by renjukpaily, Mar 2, 2006.

  1. renjukpaily New Member

    Hi all,
    I have developed a web application which displays records stored in the database based on certain criteria supplied by the user. I have used SQL Reporting services for generating a report coresponding to the displayed records. The problem I faces is as follows.
    I generated a report for the records displayed in the application. Then, I updated one of the records and again generated the report. But the change I made is not reflected in it. The report is the same as the one previously generated. But the change is reflected if I logged out of the application, again logged in and generated the report.
    I checked the 'Execution properties' of the report in the Report Manager and I found that the 'Do not cache temporary copies of this report' option remains selected. But the caching problem exists. Please help if anyone knows a solution. I am desperately in need of a solution for the above problem.
  2. satya Moderator

    Have you searched for relevant information on RS Books online, I think there should be some kind of setting to avoid this issue. May also search under RS Newsgroups for any relevant information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. smy New Member

    use &rs:ClearSession=true if you are calling the report in URL format..else you can set the report to auto refresh at an interval

Share This Page