Hi guys,
I have seen that many people have had questions regarding passing report parameters in urls. I decided that I would document my specific case here as I did not find much information on it. I am working with SSRS 2008 R2 and in Sharepoint Integrated Mode.
I will just get right down to it. To correctly pass parameters to a report, use a url that follows the following pattern (assume that we have a "ssrs reports" folder in our SharePoint subsite, where we store our reports):
http://<<spsite>>/<<spsubsite>>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<<subsite>>/ssrs%20reports/<<report_name>>.rdl&rp:<<param1>>=<<param_value1>>&rp:<<param2>>=<<param_value2>>
The important thing to note is that for every parameter it is necessary to include the "rp" prefix.
I hope this helps some of you.
Please ask if I can be of more assistance.
Happy coding! :)
Hermann
I have seen that many people have had questions regarding passing report parameters in urls. I decided that I would document my specific case here as I did not find much information on it. I am working with SSRS 2008 R2 and in Sharepoint Integrated Mode.
I will just get right down to it. To correctly pass parameters to a report, use a url that follows the following pattern (assume that we have a "ssrs reports" folder in our SharePoint subsite, where we store our reports):
http://<<spsite>>/<<spsubsite>>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<<subsite>>/ssrs%20reports/<<report_name>>.rdl&rp:<<param1>>=<<param_value1>>&rp:<<param2>>=<<param_value2>>
The important thing to note is that for every parameter it is necessary to include the "rp" prefix.
I hope this helps some of you.
Please ask if I can be of more assistance.
Happy coding! :)
Hermann
