Passing parameter to ssrs report in query string in SharePoint 2010

Question

I published ssrs for sharepoint and am trying to pass the parameter value in the query string, but I could not determine the syntax. Here is the query string I pass. I am trying to pass CLordID = 1324381 . In my report, CLordID

Https: ///_layouts/ReportServer/RSViewerPage.aspx sv: RelativeReportUrl = / TestReports / Orders.rdl & RS: Command = Render & CLordID = 1324381

When I try to do this, I get:

Indicate a report of parameter values. Parameter values ​​must be specified before the report is displayed. Select the parameter values ​​in the parameter area and click "Apply." Button.

I tried to make the parameter visible, hidden and internal, but I could not get it to work.

Any help is appreciated

Answer 1

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

Answer 2

In the options parameters, under the available values, did you specify an option to specify, and then did not include any values? Install it back and you should be right.

Answer 3

There is another option, which is to render reports using the HTML viewer.

I got this idea here: http://techpunch.wordpress.com/2008/09/17/sql-server-reporting-services-url-parameters-in-sharepoint-integrated-mode/
I never know how long a blog post lasts, so I tried to summarize it below.

You can format your URL as follows:
(I was not sure about the name of your server, so I just used the "Intranet" where applicable)

 https://intranet/reportserver?http://intranet/TestReports/Orders.rdl&CLordID=1324381 

This avoids the need to add "rp:" to each parameter that you want to pass.

Answer 4

Include "rp:" before each parameter. It works like a charm.