Tuesday, August 30, 2016

Working with SharePoint Report Server 2012 using URL parameters in SSRS 2008/2012 in SharePoint Integrated Mode – Part Two

In my previous post I have explained how to pass the custom URL parameter to the Report when it is SharePoint Integrated Mode.

As explained earlier post report server parameter has three parts.

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


Parameter Type



Report Viewer Control


Report Server HTML controller

Report Server


Report Server to process

Report Viewer Web Part


Web part parameters

Report Parameters


Report parameters (Explained in Part One)

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

You can find similar page if report server is running.




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


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


These parameters are send to Report Server itself.

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


    • listChildren

    • GetChildren

    • Render

    • GetDataSourceContents

    • GetResourceContents


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

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

No comments: