I am caching my report once every week as it takes forever to load. But I want my report users to be able to see the date when the data in the report was last refreshed. Is there a way I can add that date to my report?
Tried using Now but it just gives the date and time of when I am opening the SSRS report and not exactly when it was last cached.
2
You can get the last run details by querying the report server database.
Select top 1 * from ExecutionLog
this table has all execution details and you can filter out your report with a join of the Catalog table.
1