|During a recent SQL Server Reporting Services Consultancy the client asked "How do I get SQL Server Reporting Services 2008 R2 to automatically refresh the report, when viewed within Report Manager?"|
To achieve this the answer is quite simple, as one can use the reports' AutoRefresh property.
- Load up the Properties Pane, by either using the view menu or by pressing F4 on the keyboard
- In the Properties dropdown at the top select Report
- Find the Other Category within the Properties Pane.
- In the space to the right of the AutoRefresh property enter the number of seconds that has to relapse before the report is refreshed.
A word of caution when using this. The lower the number entered the more often the report will refresh, which could have an negative impact on the performance of the underlying database as the queries that drives the report will be constantly executed.
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us