Problem with Reporting Services
Posted on 2006-11-03
I am calling a report developed in reporting services from my aspx page. I am passing the order Number as the parameter to the report. I am using the following path to access the report.
strReportPath = ConfigurationSettings.AppSettings("ReportingServicesDirectURL") & "/CommercialInvoice&rs:command=Render&Order_Number=" & strOrderNo
On a button click, I am calling the above report, and while calling I am doing some changes to the database.
But the report is not showing the changes if I call the report for same order number for a second time. The report is not getting the values from the database for the same order number. But it is displaying the previous values. It is working fine if I change the order number.
I guess the problem is, for the same report and same parameters, the reporting services are not executing the database again, but getting the values from some tempararily stored location.
How to make the report to look the database, every time a report is executed irrespective of same parameter or different parameter.
this is a big problem for me. I have some other reports with the same problem.
Thanks in advance.