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.

3 comments:

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,

Derrick

tike mik said...

Most selling systems and related processes include a meeting and greeting, an initial manager T.O. to qualify the customer's needs, an inventory and facility walk, a test drive, a feature benefit presentation, a desking procedure, a manager T.O., negotiations, an F&I introduction, a delivery procedure and service introduction. Toolschief

tike mik said...

Any of these will keep you up-to-date on what's happening, and in particular, how it will affect you. cbd capsules portland