Auto Refresh SSRS in SharePoint 2010


I have been working on some dashboards in SharePoint 2010 and Reporting Services 2008 R2 for a client.

There are a series of Gauges and Charts all set to refresh every 60 seconds, which work fine when deployed to a Native Report Server.
They also work individually when deployed into a Reports library in SharePoint integrated  mode.

However, when I added more than one of them to a web part page, using the SQL Server Reporting Services Report Viewer web part, only the last web part on the page would refresh.

Some of the web parts in SharePoint 2010 now have the option of AJAX settings, including how often to auto refresh.  Unfortunately these aren’t options on the SQL Server Reporting Services Report Viewer web part, so I had to think outside of the web parts I was using.

The solution I hit upon was to add a Content Editor web part and link to a small JavaScript text file held in a document library.

The various dashboards all reference this file which is set to refresh every 60 seconds.

<script type=”text/javascript”>
// The time out value is set to be 60,000 milli-seconds (or 60 seconds)
setTimeout(‘ document.location=document.location’ ,60000);
</script>

It’s a bit disappointing that I couldn’t get this to work using standard set up, maybe there is a way?

Advertisements

One thought on “Auto Refresh SSRS in SharePoint 2010

  1. Pingback: Auto Refresh SSRS Reports in SharePoint 2010 « Richard Mintz's BI Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s