There is a slightly different 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 passing to SSRS engine using prefix.
Report Viewer Control
Report Server HTML controller
Report Server to process
Report Viewer Web Part
Web part parameters
Most of the time passing parameters to report is more frequently used than any other Passing the Reports as a URL Parameter
Assume that we have created a Report with parameter interval and need to pass the values from the URL.
Let’s see the attributes of the @interval parameter.
I have mentioned the visibility as 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 having url something like below.
Assume that you need to pass the parameter “interval” in url. Thus you need to append the following URL parameter.
URL parameter has three sections
Prefix - rp:
Parameter name - interval
Value – cm
So your final URL will be something like follows
http://www.myportal.com/_layouts/15/ReportServer/RSViewerPage.aspx? &rv:RelativeReportUrl=/ReporlLocation/myreport.rdl&rc:Parameters=Collapsed& rp:interval=cm