Tuesday, May 8, 2012

Auto refresh of SSRS reports.


In some situations you want to use a SSRS report to monitor activity on your solution which requires some action of people. For instance your internal helpdesk has made an overview of the number of logged errors in the last 10 minutes. This overview will help the helpdesk in their daily operation. In SSRS you can configure your report to refresh automatically. Of course you should be very carefully in implementing this feature. It can result in a lot of recurring datbase activity which can have a big impact on the overall performance of your solution.

To configure auto refresh of your report, open the property windows of your Report. In the Other section you will find a property AutoRefresh. Sets its value to 60 and the report will auto-refresh every 60 seconds.




Picture: Milford Sound, New Zealand Dec 2011.

2 comments:

Derrick Attfield said...

Hi, Do you perhaps know any way to achieve the RDL based report auto refresh for custom SSRS reports in the CRM365 online scenario? Just using the autorefresh property results in the refresh running but the data is not updated. In the CRM365 online scenario I have not been able to find how to pass rs: parameters - with a SSRS report server one would just & append the parameters, in the CRM365 online context such parameters are not accepted.

Thank you for your comments

Best regards,

Derrick

Gerry Witjes, Canvation Group said...

Hi, I had used your blog comment to implement this Auto Refresh strategy on SQL Server 2012 SSRS very successfully. In fact, I used an expression with a Report parameter in the Auto Refresh field to allow the report user to enter their own refresh value, or 0 (default) for no refresh.

Was fantastic, thanks!

We just migrated to SQL Server 2016 SP2 CU3 SSRS (in Native Mode), and ported the ReportServer and ReportServerTempDB databases and Encryption Keys from the 2012 to 2016 versions and now have all our reports, including subscriptions, running from the new SSRS.

Unfortunately, the Auto Refresh feature does some strange things that it didn't do in SSRS 2012. In 2016 SSRS, it steals the window focus whenever the Auto Refresh activates. This is incredibly annoying, and will not be appreciated/accepted by the end-users should we roll out this new Report Server.

I tried opening the report in the new Report Builder 2016, and saving it to a fresh Report Server folder location, but get the same result.

Thoughts / Ideas?

Thanks,
Gerry