reporting server 2008 caching the reports
Hello, It always caching the report and opens the old copy of PDF. Here is the report link I am using. Could you please let me know what could be the problem? Thanks for any suggestions. string url = string.Format("{0}{1}", ConfigurationManager.AppSettings["RS_Viewer"] + "?/" + "Test" + "/" + "Test_Data" + "&rs:Command=Render&rs:Format=PDF&rs:ClearSession=true&MyID=", MyID); Page.ClientScript.RegisterStartupScript( this.GetType(), "OpenWin", "<script language=javascript>function DisplayReport() { window.open ('" + url + "', null,'top=20,left=20,center=yes,resizable=no,Width=300px,Height= 200px,status=no,titlebar=no;toolbar=no,menubar=no,location=no,scrollbars=yes');return false;}</script>"); ViewFile.Attributes.Add("OnClick", "return DisplayReport();"); Also I tried to set Do not cache temporary copies of this report" in the Report Manager. But I still have the same issue.
May 29th, 2012 1:11pm

Hello anate, I want to confirm the following things about this report. Did you check the report in the ReportViewer or report manager directly to see whether it returns the latest or old report? If the report on report manager also render the old one, it is possible that the report has the problem. We need check whether the dataset access a snapshot on the server, which is not refresh. In addition, if all works well, please check run the query of dataset in the SMSS to see whether the result returns the latest value. If not, please check the data source to see whether it is updated properly. I hope the above troubleshooting idea is helpful to you. If you still exists the problem, please contact me. Regards, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2012 2:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics