April 14, 2021 at 7:33 pm
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?
April 15, 2021 at 8:52 am
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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 15, 2021 at 10:59 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply