SharePoint Report Server 2012: Using URL parameters in SSRS 2008/2012 in SP Integrated Mode (Part 2)

In a previous post, it was explained how to pass the custom URL parameter to a report when it is SharePoint Integrated Mode.

As explained in an earlier post, report server parameter has three parts.

<prefix>:<Parameter Name>= <Value>

When you are running the Report Server under SharePoint, you can access the report server using /_vti_bin/reportserver.

You can find a similar page if report server is running.

https://lh3.googleusercontent.com/-2u7_vgzxoE8/WLuq_eip9vI/AAAAAAAAPmE/m5rPYK9k3jk/image_thumb%25255B2%25255D.png?imgmax=800

rc:

This is for passing parameters to Report Server HTML viewer.

Here are the list of parameters.

• rc:Parameters
• rc:Zoom
• rc:Section
• rc:FindString
• rc:StartFind
• rc:EndFind
• rc:FallbackPage
• rc:GetImage
• rc:Icon
• rc:Stylesheet

EX: - http://mysharePoint/_vti_bin/ reportserver?<Document Library URL>&rc:Parameters=Collapsed

There are few other options you can find it using this link:

REF: https://msdn.microsoft.com/en-us/library/ms152835.aspx

rv:

This is used to pass parameters to Report Server Web Part.

These are the parameters for SharePoint Report Server Web Part.

• rv:Toolbar
• rv:HeaderArea
• rv:DocMapAreaWidth
• rv:AsyncRender
• rv:ParamMode
• rv:DocMapMode
• rv:DockToolBar
• rv:ToolBarItemsDisplayMode

EX: - http://mysharePoint/_vti_bin/ reportserver?<ReportURL.RDL>&rv:Toolbar=full

REF : https://msdn.microsoft.com/en-us/library/ms152835.aspx

rs:

These parameters are send to Report Server itself.

These are the parameters for SharePoint Report Server. There are two kind of parameters.

rs:Command

• • listChildren

  • GetChildren

  • Render

  • GetDataSourceContents

  • GetResourceContents

EX: http://<mySharePOint>/_vti_bin/reportserver?<Document Library>&rs:Command=GetChildren

• rs:Format
• rs:ParameterLanguage
• rs:Snapshot
• rs:PersistStreams
• rs:GetNextStream
• rs:SessionID
• rs:ClearSession
• rs:ResetSession
• rs:ShowHideToggle

http://<mySharePOint>/_vti_bin/reportserver?<Document Library>&rs:Format=PDF

References

• https://msdn.microsoft.com/en-us/library/ms152835(v=sql.110).aspx