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.


Unknown 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,


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?


Sumon Rana said...

Someone essentially help to make significantly articles or blog posts I would state. This really is the first time I frequented your site web page and thus much? I surprised with the research you created to create this distinct publish extraordinary. Amazing job! used cars for sale in nigeria

information technology said...

Do you know that it is important to note that the pictures of the new supercar, published by the press service of the automaker, could well depict one of the early test prototypes of the MC20. A car photographed near Maserati's headquarters in Modena seems to be wearing at least a few fake body panels in an attempt to hide the actual shape and size of the car. In addition, photographs were taken at night. Regardless of its direction of design, the new double Italian “rocket” can boast a fairly powerful technical stuffing. According to preliminary information, the new MC20 will be equipped with a Maserati turbocharged V6 engine, which boasts more than 600 horsepower. Nothing has been confirmed at the moment, but according to the latest rumors, the six-cylinder power unit will be connected to an carzaamin(.)com/blog/honda-city-for-sale-in-lahore-pakistan/ eight-speed dual-clutch automatic transmission. It is assumed that buyers will also be offered an electrified version of the new product, under the hood of which there will be a hybrid engine. Thanks