SSRS 2008 R2 - Parameters passed through URL do not refresh
Hi, I have a solution of reports in developed in SSRS 2005, and when I install them in SSRS 2005 or 2008 they work fine, but when I install them in SSRS 2008 R2 the parameters do not refresh, when I invoke a new report. I pass the parameters through an URL. Example: http://sql2008R2/Reports/Pages/ReportViewer.aspx?/app/report_1&par1=01-01-2011&par2=06-05-2011 &rc:DocMap=false&Rc:parameters=False&rs:Command=Render In this report I can pass these parameters or not, they’re not obligatory, which means the report can receive one or both parameters as null. What happens is if I apply the parameter ‘par1’, and invoke the report, it presents its values correctly; the problem is if after applying one or more parameter to the report, I invoke the report without the parameters. The URL is created correctly without the parameters, but when I change parameters=true, to see which what values are being passed to the report, it shows the previous parameters that I applied in the beginning. If I invoke the first time the report without the parameters, it shows the correct values, but if after applying one or more parameters to the report, I can’t remove them, the report gets the last applied filter, always. So anyone has any solution to this problem?
May 6th, 2011 12:28pm

Hi Mephus, From your scenario, it seems that you would like to pass parameter via URL to reports that is on report manager. Based on my experience, we can pass report parameters to a report by including them in a report URL, but we should find the report URL on report server not report manager. So this is the root cause of your scenario. The default directory path of report server is http://SeverName/ Reportserver. Please take the following link as a sample: http://servernname/ReportServer/Pages/ReportViewer.aspx?%2fSales%2fPacific+Reseller+Sales+Margin+Analysis&rs:Command=Render &rc:Parameters=false&Year=2001 For more details about how to pass parameters to a report via URL, please refer to the following article, Using URL Access Parameters: If you have any question, please feel free to ask. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 2:59am

Thank you for your answer. But unfortunately, the solution you provided did not work. Is there anything else I could try, i must emphasize that this only happens on SSRS 2008 R2. Thank you
May 16th, 2011 1:05pm

Hi shamen, I have tested on SSRS 2008 R2, and the solution worked also. Please make sure you are testing on report server but not report manager. Report Server URL: http://ServerName/Reportserver Report Manager URL: http://ServerName/Reports We cannot pass parameter via report manager url, but report server url can do it, there is no difference between SSRS 2008 and SSRS 2008 R2 in this aspect. Please see the following article and hope it could help you, Passing parameters and other options directly through a URL in Reporting Services: If you have any questions, please feel free to ask. Thanks. Eileen
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2011 10:29pm

Hello Eileen Thanks for this clarification. Is there a way to pass ing the credentials as well without the user having to enter them? Jawahar Rajan
May 24th, 2012 4:59pm

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

Other recent topics Other recent topics