Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Passing parameter to ssrs report in query-string in SharePoint 2010

I published an ssrs to sharepoint and am trying to pass the value of parameter in the query string but I haven't been able to figure out the syntax. Here is the query-string that I'm passing in. I am trying to pass the CLordID = 1324381. In my report CLordID

https:///_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/TestReports/Orders.rdl&rs:Command=Render&CLordID=1324381

When I try this I receive:

Specify Parameter Values Report parameter values must be specified before the report can be displayed. Choose parameter values in the parameters area and click the Apply button.

I have tried making the parameter, visible, hidden, and internal, but I haven't been able to get it to work.

Any help is greatly appreciated

like image 991
mikemurf22 Avatar asked Apr 01 '11 20:04

mikemurf22


1 Answers

In SSRS 2008 with Sharepoint, you need to prefix each parameter passed in the URL with "rp:". For example: https:///_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/TestReports/Orders.rdl&rs:Command=Render&rp:CLordID=1324381

like image 188
Steve Goedker Avatar answered Sep 28 '22 09:09

Steve Goedker