Welcome to MSDN Blogs Sign in | Join | Help

Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

If want your report to auto refresh every x seconds inside IE, take a look at the AutoRefresh RDL element: <AutoRefresh> is a child of <Report> and a peer or the <Body> element in your document. For example, if you want your report to autorefresh every 15 seconds, you'd add the AutoRefresh element to the RDL in your report like so:

<Report>

     <AutoRefresh>15</AutoRefresh>

     <Body>

      ...

     </Body>

</Report>

  

...Thanks toMike Schetterer

Published Wednesday, July 13, 2005 1:39 PM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Wednesday, January 18, 2006 4:58 PM by Denis
I'm using a link from other web site to my report, which is saved with autorefresh element. The link has a form of:

http://myserver/REPORTSERVER?(name_of_report)&rs:Command=Render

(plain and simple)

When i follow this link the report renders in IE and re-freshes number of seconds requested, however data on it stays the same all the time (cached?). If I press "refresh" button on report toolbar at this point - after that it starts showing new data each time it re-freshes.

What could be wrong?

Any suggestion appreciated.

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Saturday, January 21, 2006 7:31 PM by russch
You're running into some session-based caching that is baked into the product. Try adding rs:ClearSession=true to the end of your string and see if that helps.

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Wednesday, March 22, 2006 10:26 AM by Bert Van Kets
I would like to be able to switch the auto refresh function OFF with a button/select/whatever on the report itself. Is there any way to do this. I have searched everywhere.

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Thursday, March 23, 2006 10:01 AM by russch
Nope...This is directly in the RDL, so there's no way to really change it. Sorry.

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Thursday, March 23, 2006 4:44 PM by Shannon
THANK YOU!!! THIS HELPED ME A LOT!

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Wednesday, November 01, 2006 9:52 PM by Luc Morin

I'm trying to implement this solution for a report accessible through the Report Manager.

It works fine if one provides URL access to the report, but what if the user simply uses the Report Manager web interface ?

Is there any way to customize the URL used on Report Manager in order to include the rs:ClearSession=true parameter ?

Thank You

Luc

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Thursday, February 15, 2007 3:55 AM by Will Casey

The auto refresh is great but if I have groups open they close on the refresh is there anyway to have the sheet remain as it is visually?

For example one group open and all the others collapsed.

Will

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Monday, November 19, 2007 2:32 PM by Mike Chaliy

Exactly the same issue like Will Casey have.

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Monday, February 04, 2008 4:24 AM by John Coner

Thank you so much.

It's working

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Monday, March 31, 2008 9:49 AM by jane

Why not using the AutoRefresh property under Report?

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Tuesday, February 03, 2009 3:05 AM by Sanjay Nipane

Hello, I am using ReportViewer control with ASp.NET 2.0. I want to set refresh interval programmatically as I want to make it configurable. I can set auto-refresh at design-time but run-time doesn't provide any properties. Any suggestions?

# re: Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

Thursday, February 26, 2009 5:10 AM by Dean

Hi Mike very useful.

I have designed a report like a Web Page and I have used this as a Dashboard. To show the status of the data in the system.

Regards

Dean

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker