Go to: Reporting Service Report-using URL access parameters

To: http://msdn.microsoft.com/en-us/library/ms152835.aspxUsing URL access parameters

You can use the following parameters as part of a URL to configure the look of your reports. The most common parameters are listed in this section. parameters are case-insensitive and begin with the parameter prefixRS:If directed to the Report Server andRC:If directed to an HTML viewer. You can also specify parameters that are specific to devices or rendering extensions. For more information about device-specific parameters, see specifying device information settings in a URL.

HTML viewer commands

The following table describes the URL access parameters that are prefixedRC:And are used to target the HTML viewer.

Parameter	Action
Toolbar	Shows or hides the toolbar. If the value of this parameter isFalse, All remaining options are ignored. If you omit this parameter, the toolbar is automatically displayed for rendering formats that support it. The default of this parameter isTrue.
Parameters	Shows or hides the parameters area of the toolbar. If you set this parameterTrue, The parameters area of the toolbar is displayed. If you set this parameterFalse, The parameters area is not displayed and cannot be displayed by the user. If you set this parameter to a valueCollapsed, The parameters area will not be displayed, but can be toggled by the end user. The default value of this parameter isTrue.
Zoom	Sets the report zoom value as an integer percentage or a String constant. Standard string values includePage widthAndWhole page. This parameter is ignored by versions of Microsoft Internet Explorer earlier than Internet Explorer 5.0 and all non-Microsoft browsers. The default value of this parameter is100.
Section	Sets which page in the report to display. Any value that is greater than the number of pages in the report displays the last page. Any value that is less0Displays page 1 of the report. The default value of this parameter is1.
Startfind	Specifies the last section to search. The default value of this parameter is the last page of the report.
Endfind	Sets the number of the last page to use in the search. For example, a value5Indicates that the last page to be searched is page 5 of the report. The default value is the number of the current page. Use this parameter in conjunction withStartfindParameter.
Fallbackpage	Sets 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	Gets a participant icon for the HTML viewer user interface.
Icon	Gets the icon of a participant rendering extension.
Stylesheet	Specifies a style sheet to be applied to the HTML viewer.

You can pass additional parameters on a URL to direct the output for HTML Rendering. For more information, see HTML device information settings.

Report Server commands

The following table describes the URL access parameters that are prefixedRS:And are used to target the Report Server.

Parameter	Action
Command	Specifies the last section to search. The default value of this parameter is the last page of the report.
Format	Specifies the format in which to render a report. common values includeHtml3.2,Html4.0,MHTML,Image,Excel, Word,CSV,PDF,XML, AndNull. For more information, see specifying a rendering format in a URL.
Parameterlanguage	Provides a language for parameters passed in a URL that is independent of the browser language. The default value is the browser language. The value can be a culture value, suchEn-USOrDe-de.
Snapshot	Renders a report based on a report history snapshot. For more information, see rendering report history snapshots using URL access.
Persiststream	Renders a report in a single persisted stream. this parameter is used by the image Renderer to transmit the rendered report one chunk at a time. after you use this parameter in a URL access string, use the same URL access string, cannot replacePersiststreamParameter withGetnextstreamParameter to get the next chunk in the persisted stream. This URL Command will eventually return a 0-byte stream to indicate the end Of the persisted stream. The default value isFalse.
Getnextstream	Gets the next data chunk in a persisted stream that is accessed by usingPersiststreamParameter. For more information, see the descriptionPersiststream. The default value isFalse.

Report viewer Web Part commands

The following table describes the new SQL Server 2008 reserved report parameter names that are used to target the report viewer Web part when reporting services is integrated with Windows SharePoint Services (WSS) 3.0 or Microsoft Office Sharepoint Server (MOSS) 2007. these parameter names are prefixedRV:. The report viewer Web Part also acceptsRS: parameterlanguageParameter.

Parameter	Action
Toolbar	Controls the toolbar display for the report viewer Web part. The default value isFull. Values can be: Full: Display the complete toolbar. Navigation: Display only pagination in the toolbar. None: Do not display the toolbar.
Headerarea	Controls the header display for the report viewer Web part. The default value isFull. Values can be: Full: Display the complete header. Breadcrumbsonly: Display only the bread-crumb navigation in the header to inform the user where they are in the application. None: Do not display the header.
Docmapareawidth	Controls 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	Controls whether a report is rendered asynchronously. The default value isTrue, Which specifies that a report be rendered asynchronously. The value must be a Boolean valueTrueOrFalse.

Examples

The following example hides the HTML viewer toolbar by settingRC: ToolbarParameter ValueFalse:

Copy code

http://<Server Name>/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

The following example passes a hard-coded parameter and hides the input field for user-supplied parameters:

Copy code

http://<Server Name>/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&Year=2002

The following example usesRC: ZoomParameter to set the zoom property of the reportPage width:

Copy code

http://<Server Name>/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width

The following example toggles section 13 of the report: