Compartilhar via

Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element

  • Artigo

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

Comments

  • Anonymous
    January 18, 2006
    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.

  • Anonymous
    January 21, 2006
    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.

  • Anonymous
    March 22, 2006
    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.

  • Anonymous
    March 23, 2006
    Nope...This is directly in the RDL, so there's no way to really change it. Sorry.

  • Anonymous
    March 23, 2006
    THANK YOU!!! THIS HELPED ME A LOT!

  • Anonymous
    November 01, 2006
    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 YouLuc

  • Anonymous
    February 14, 2007
    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

  • Anonymous
    November 19, 2007
    Exactly the same issue like Will Casey have.

  • Anonymous
    February 03, 2008
    Thank you so much.It's working

  • Anonymous
    March 31, 2008
    Why not using the AutoRefresh property under Report?

  • Anonymous
    February 02, 2009
    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?

  • Anonymous
    February 25, 2009
    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.RegardsDean

  • Anonymous
    June 30, 2011
    The comment has been removed

  • Anonymous
    May 09, 2012
    Thanks.  This a great property to know about.

  • Anonymous
    March 12, 2014
    Thank you...It resolved my session time out issue.

  • Anonymous
    September 10, 2014
    I am new to reporting services in 2008.  I have created a report and it is working. However, I can't get the data to refresh.  I only have 1 dataset to a database table. What am I doing wrong that it won't refresh ?  Thank You