You can use parameters as part of a URL to configure the look and feel of your SQL Server 2016 (13.x) Reporting Services or later (SSRS) reports. This article describes the most commonly used parameters.
Parameters aren't case sensitive. They require a prefix:
rs:: Targets the report server.
rc:: Targets an HTML Viewer.
rv:: Targets the Report Viewer web part.
You can also specify parameters that are specific to devices or rendering extensions. For more information about device-specific parameters, see Specify device information settings in a URL.
Important
For a SharePoint mode report server, it's important that the URL includes the _vti_bin proxy syntax to route the request through SharePoint and the Reporting Services HTTP proxy. The proxy adds context to the HTTP request that's required to ensure proper execution of the report for SharePoint mode report servers. For examples, see Access report server items by using URL access.
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
HTML Viewer commands (rc:)
Target the HTML Viewer by using the prefix rc:.
Command
Parameter
Description
Toolbar
True
Displays the toolbar. The default value is true.
Note: If you omit this parameter, the toolbar is automatically displayed for rendering formats that support it.
Toolbar
False
Hides the toolbar. If this parameter is false, all remaining options are ignored.
Toolbar
Navigation
Displays only pagination in the toolbar.
Parameters
True
Displays the parameters area of the toolbar. The default value is true.
Set the report zoom to a specific percentage. The default value is 100.
Section
<page number>
Set which page in the report to display. Any value greater than the number of pages in the report displays the last page. Any value less than 0 displays page 1 of the report. The default value is 1.
Search a report for a specific set of text and highlight the text. Note:rc:FindString doesn't work unless you include rc:Toolbar=false in the URL access string.
Set the number of the last page you want to use in the search. The default value is the number of the current page. Use this parameter with the StartFind parameter.
Example: See the StartFind example.
FallbackPage
<page number>
Set the number of the page to display if a search or a document map selection fails. The default value is the number of the current page.
GetImage
<icon name>
Get a particular image for the HTML Viewer user interface.
Icon
<icon name>
Get the icon of a particular rendering extension.
Stylesheet
<stylesheet file name>
Specify a style sheet you want to apply to the HTML Viewer.
Device Information Setting
Specify a device information setting in the form of rc:tag=value, where tag is the name of a device information setting specific to the rendering extension. For more information, see the Format command description.
You can use the OutputFormat device information setting for the IMAGE rendering extension to render the report to a JPEG image by using the following parameters in the URL access string: ...&rs:Format=IMAGE&rc:OutputFormat=JPEG. For more information on all extension-specific device information settings, see Device information settings for rendering extensions (Reporting Services).
Report server commands (rs:)
Target the report server by using the prefix rs:.
Command
Parameter
Description
Command
ListChildren and GetChildren
Display the contents of a folder. The folder items display within a generic item-navigation page.
Display the XML definition associated with a shared dataset. Shared dataset properties are saved in the definition. These properties include the query, dataset parameters, default values, dataset filters, and data options such as collation and case sensitivity. You must have Read Report Definition permission on a shared dataset to use this value.
Display the properties of a given shared data source as XML. If your browser supports XML and if you're an authenticated user with Read Contents permission on the data source, the data source definition displays.
Render a resource and display it in an HTML page if the resource is compatible with the browser. Otherwise, you can choose to open or save the file or resource to disk.
Display the XML definition associated with a published report item. You must have Read Contents permission on a published report item to use this value.
Format
HTML5 PPTX ATOM HTML4.0 MHTML IMAGE EXCEL (for .xls) EXCELOPENXML (for .xlsx) WORD (for .doc) WORDOPENXML (for .docx) CSV PDF XML
Specify the format in which to render and view a report. The default value is HTML5. For more information, see Export a report by using URL access. For a complete list, see the \<Render> extension section of the report server rsreportserver.config file. For more information, see RsReportServer.config configuration file.
Render a report in a single persisted stream. The Image renderer uses this parameter to transmit the rendered report one chunk at a time. After using this parameter in a URL access string, use the same URL access string with the GetNextStream parameter instead of the PersistStreams parameter to get the next chunk in the persisted stream. This URL command eventually returns a 0-byte stream to indicate the end of the persisted stream. The default value is false.
GetNextStream
true false
Get the next data chunk in a persisted stream that's accessed by using the PersistStreams parameter. For more information, see the PersistStreams command description. The default value is false.
SessionID
Specify an established active report session between the client application and the report server. The value of this parameter is set to the session identifier.
You can specify the session ID as a cookie or as part of the URL. When you configure the report server to not use session cookies, the first request without a specified session ID results in a redirection with a session ID. For more information about report server sessions, see Identify execution state.
ClearSession
true false
Remove all report instances associated with an authenticated user from the report session. A report instance is defined as the same report run multiple times with different report parameter values. The default value is false. Valid values are true and false.
ResetSession
true false
Reset the report session by removing the report session's association with all report snapshots. The default value is false. Valid values are true and false.
ShowHideToggle
<positive integer>
Toggle the show and hide state of a section of the report. Specify a positive integer to represent the section to toggle.
Report Viewer web part commands (rv:)
Target the Report Viewer web part that integrates with SharePoint by using the prefix rv:. The Report Viewer web part also accepts the rs:ParameterLanguage parameter.
Command
Parameter
Description
Toolbar
Full
Displays the complete toolbar. The default value is Full.
Control the display width, in pixels, of the parameter area in the Report Viewer web part. The default value is the same as the Report Viewer web part default. The value must be a non-negative integer.
AsyncRender
true false
Control whether a report is rendered asynchronously. The default value is true, which specifies that a report be rendered asynchronously. The value must be a Boolean value of true or false.
ParamMode
Full
Displays the parameter prompt area. The default value is Full.
Control which toolbar items to display. This value is a bitwise enumeration value. To include a toolbar item, add the item's value to the total value. For example, for no Actions menu, use rv:ToolBarItemsDisplayMode=63 (or 0x3F), which is 1+2+4+8+16+32. For Actions menu items only, use rv:ToolBarItemsDisplayMode=960 (or 0x3C0). The default value is -1, which includes all toolbar items. Valid values are:
Learn how URL access of the report server in SQL Server Reporting Services (SSRS) enables you to send commands to a report server through a URL request.