Post reply

Reports seem to be caching and how do I turn it off

  • May 22, 2017 at 8:24 am

    #330612

    hello,

    I found an article that tells how to create a report, display a status and then change the status by click on a column in the row on the report.

    It works.  Sometimes.

    I can see that item and status on the report.  I've set up an interactive report that takes me another report and changes the status.  The interactive report is built on a stored procedure that changes the status if clicked.

    There are times when I go back to the original report, the value still shows the same status.  I query the database, I see that it has changed.  However, the report is showing me the same status.

    I imagine that it is due to caching.  How do I insure the report always looks at the latest value in the database?

    Thanks.

    Tony

    Things will work out.  Get back up, change some parameters and recode.

  • May 23, 2017 at 8:49 am

    #1943811

    WebTechie - Monday, May 22, 2017 8:24 AM

    hello,

    I found an article that tells how to create a report, display a status and then change the status by click on a column in the row on the report.

    It works.  Sometimes.

    I can see that item and status on the report.  I've set up an interactive report that takes me another report and changes the status.  The interactive report is built on a stored procedure that changes the status if clicked.

    There are times when I go back to the original report, the value still shows the same status.  I query the database, I see that it has changed.  However, the report is showing me the same status.

    I imagine that it is due to caching.  How do I insure the report always looks at the latest value in the database?

    Thanks.

    Tony

    If this is a live report then check the processing options for the report in Report Manager. Select Always run this report with the most recent data and Do not cache temporary copies of this report. Also try refreshing the browser
    If this is in development it depends on which tool and what version you are using. For report builder try clicking on the refresh when viewing. For business intelligence studio, try this solution - I think it's similar for some of the other VS environments as well:
    Clear Report Data Caches from Within SQL Reporting Services Business Intelligence Studio (BIS)

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply