Making Reporting Services reports refresh automatically
A little nugget of information - how to arrange it so that a report written using SQL Server Reporting Services will keep refreshing automatically, to display the latest data.

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:

Sample films report

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:

Selecting a 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:

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.

 

This blog has 0 threads Add post