BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 30 January 2012
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
How to Automatically Refresh SSRS 2008 R2 Reports
Someone asked me on a Reporting Services course today how you could get a report to refresh automatically every few seconds or minutes. The answer is so refreshingly simple I thought I'd share it!
The Problem
You have a report which people can view from your company's Intranet:

Your report shows a list of the latest films - but this can change at any moment
However, the data changes all the time, and you want the report to refresh continuously. You could do this in a web page by setting a metatag, but how to do it in SSRS?
The Answer
The solution is to reset the AutoRefresh property of the report. First select the report:

Click outside any report to select it, then choose to show its Properties pane (one of many ways to do this is to press F4).
In the report's Properties pane, change the AutoRefresh property:

Type in the number of seconds which should elapse before the report reloads.
When you preview or deploy this report, it will now reload every 10 seconds!
This is as good a way as any to make yourself unpopular with your IT department! If your report is refreshing its underlying data every 10 seconds, that's a lot of data traffic you're creating.