Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Refresh only a portion of Report Page Expand / Collapse
Author
Message
Posted Friday, February 21, 2014 1:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:10 AM
Points: 25, Visits: 56
My SSRS report which has been built using VS 2008 (SQL Server 2008 R2), has 2 tables and 2 graphs. Is it possible to refresh only the contents inside one table periodically.

Please note that , there are no report parameters for this report

Basically I am looking for something like AJAX controls , where-in only part of the webpage can be refreshed...

Please help
Post #1543861
Posted Friday, February 21, 2014 7:17 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 490, Visits: 1,463
There is a AutoRefresh option on the report properties which you set the rate in seconds when rendered in HTML.

I have never tried it so can't comment if it does do the trick and if you can set it only for a sub report.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/34a94a3d-46fb-4001-a0e7-ca37840e4ef8/ssrs-report-auto-refresh
Post #1543964
Posted Friday, February 21, 2014 10:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:10 AM
Points: 25, Visits: 56
Hi,
Can we set Auto-Refresh option for only a table , in a Report which has 2 tables ?.

I think an Auto-Refresh option for the Report, will refresh the entire Report, but I want to know , if only a portion of the Report ,ie. only 1 table can be refreshed.
Post #1544113
Posted Friday, February 21, 2014 11:08 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 490, Visits: 1,463
Never tried. I'll knock something up and give it a try :)
Post #1544136
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse