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 various dashboards all reference this file which is set to refresh every 60 seconds.
// The time out value is set to be 60,000 milli-seconds (or 60 seconds)
setTimeout(‘ document.location=document.location’ ,60000);
It’s a bit disappointing that I couldn’t get this to work using standard set up, maybe there is a way?