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]
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?