Wednesday, March 7, 2012

report server refresh question

Hello

I'm new at creating reports in reporting services and I have a basic question.
My problem is that for some reason my reports don't refresh right away, even after I press the recycle button.

I change a value on the table on a database and click on the refresh button of the report. But I have to give it sometime and click the refresh in order for the report to show the changed data.

I have some charts in the report as well, so maybe I'm missing a configuration setting somewhere.

Please help a newbie out.

Thanks
Peter

For clarification,

1. Is your reports pointing to the same table to which you are doing the update?

Another thing to try is to go back and refresh the page and now click on the report name again to reload. See, if this works.

|||

Please make sure that the recycle button you are pushing is the small green one in the top of the ReportViewer control and not the browser refresh.

Check the Properties of the deployed report under Execution and see if caching has been turned on.

Larry

|||The rendered report is cached based on the CleanUpCycle config entry and it is not advisable to modify that from the default 10 [mins]. Try to use add "&rs:ClearSession" to the url of the report and check if the report is refreshed with latest data.|||Hi,
You can do one thing,After any modification in the Database.Come to VS 2005,refresh the Dataset Window(you will get from View Tool Bar).
Probably the changed will be reflected.

Cheers,
Shri|||great thank you for all the responses. All the tips have been usefull.

No comments:

Post a Comment