Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
https://lh3.googleusercontent.com/--odo7hGKdkQ/WLOq71OogUI/AAAAAAAAPgI/odJT2Z_d81o/image_thumb%25255B4%25255D.png?imgmax=800
Let’s see the attributes of the @interval parameter.
https://lh3.googleusercontent.com/-SFc00k_e2jE/WLOq9cH4DeI/AAAAAAAAPgQ/xDYw1NJfxRI/image_thumb%25255B3%25255D.png?imgmax=800
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