Wednesday, March 7, 2012

call report with datas updated

Hello,
I use sql reporting services to show reports with url and to create snapshot with his web services.
My problem is the following:
- i show a report (linked to a database with data source and dataset) with an url like :
http://srv/Reportserver/BOURGOGNE/Perso&rs:Format=HTML4.0
&rs:Command=Render&annee=2004&id=0580639E
- i change data in the database
- when a recall the report with the previous url, the data has not changed, and i must click on refresh button next the export button.
- i would like that this refresh made automatically when i call a report. for more precisions, the property/execution on this report is set to ' 'd..
thank to help me and sorry for my english...
floben.

It seems like you are rendering from session. On your URL above, append the following argument: rs:ClearSession=true

This will make sure the report gets reprocessed entirely.
See also: http://msdn2.microsoft.com/ms224719

-- Robert

|||thank, it was that..

No comments:

Post a Comment