There is a slight difference between earlier SSRS report parameters and new SSRS running in SharePoint Server 2013.

URL parameters are slightly different from Native Mode and SharePoint Mode. This article is only about SharePoint Mode parameters.

SSRS running on SharePoint has few parameter types and types are passed to SSRS engine using prefix.

Parameter Type

Prefix

Note

Report Viewer Control

rc:

Report Server HTML controller

Report Server

rs:

Report Server to process

Report Viewer Web Part

rv:

Web part parameters

Report Parameters

rp:

Report parameters

Most of the time passing parameters to reports is more frequently used than passing the reports as a URL parameter

Assume that we have created a report with a parameter interval and need to pass the values from the URL.

image

Let’s see the attributes of the @interval parameter.

image

The visibility is Visible but you can also have it as Internal as well. Internal will not be visible to users for selection.

If you are running the report from SharePoint it will have a URL something like below:

http://www.myportal.com/_layouts/15/ReportServer/RSViewerPage.aspx? &rv:RelativeReportUrl=/ReporlLocation/myreport.rdl&rc:Parameters=Collapsed

Assume that you need to pass the parameter “interval” in tURLurl. Thus you need to append the following URL parameter:

rp:interval=cm

URL parameter has three sections:

Prefix - rp:

Parameter name - interval

Value – cm

So your final URL will be something like:

http://www.myportal.com/_layouts/15/ReportServer/RSViewerPage.aspx? &rv:RelativeReportUrl=/ReporlLocation/myreport.rdl&rc:Parameters=Collapsed& rp:interval=cm