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:
http://msdn.microsoft.com/en-us/library/ms152835.aspx
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:
http://www.mssqltips.com/tip.asp?tip=1336
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