I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that was put on to the system in the last minute. The auto refresh property
on each report is set to 60 sec. to trigger the refreshing of the reports.
The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.
I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance.
The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.
I CANNOT FIGURE OUT HOW TO GET THIS TO HAPPEN, PLEASE ANY HELP WOULD BE APPRECIATED!!
I figure it is a caching issue but how to get around? HELP!
View Complete Post