SSRS Report doesn't refresh data

  • Hi all,

    I have SSRS Report that uses SP as a source. I have one filter - Activation Date and use such script for it:

    select distinct [Activation Date]

    from TableTest.

    Every month data in the TableTest updates. But in the SSRS filter I didn't see updated value.

    When I execute a query in the filter, save report and open it again - only after that I can see updated data.

    Does SSRS can update this data automatically?

  • It should update.

    SSRS does cache data between report executions, but (as far as I know) this caching is only at the session level.

    Activation Date is a runtime parameter, is that correct?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • Are you running this report within Visual Studio, or within the SSRS Web Portal? If within Visual Studio, you might want to delete the report's cached data file and then rerun the report. It'll be the rdl.data file for the report.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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