Pro SQL Server 2012 Reporting Services

CHAPTER 9  RENDERING REPORTS FROM .NET APPLICATIONS

HTML Viewer parameters (rc:): These parameters control which features of the

Web-based report viewer are active and at which page the report viewer starts

displaying the report. For example, you can use the FindString parameter to

have the viewer start displaying a report on the first page on which a specific

word is found.

Report Server command parameters (rs:): These parameters control the type of

request being made and the format of the returned report. For example, we’ll

show how to use the rs:Command=Render&rs:Format=HTML4.0 parameter to

render your report in HTML format in your report viewer.

Report Viewer Web Part command parameters (rv:): These parameters control

the SharePoint integrated web part. These are very similar to the html viewer

parameters since they will control the portal where you view reports on a

SharePoint site. For example, you can use the AsynchRender parameter to

control whether the report is rendered asynchronously or synchronously. Web

parts can also accept the rs:ParameterLanguage parameter in addition to the rv:

group.

Report Parameters

Report parameters are the actual parameters passed to the underlying report, instead of instructions
being sent to the report server. That is, you use them to pass criteria to your report, such as start and end
dates, employee IDs, and so on. You can pass these parameters to the report’s query, and they’re created
when you specify parameters for the data source. You can also use parameters as variables in the report
and as values for filters.

HTML Viewer Commands

You use HTML Viewer commands to tell SSRS 2012 how to render the report. You can use the
commands in Table 9-2 to control how the viewer appears to the user, as well as to control certain
aspects of how the report appears in the viewer.

Table 9-2. HTML Viewer Commands

Parameter Description Default

Toolbar Shows or hides the toolbar. true

Parameters Shows or hides the parameters area of the toolbar. true

DocMap Shows or hides the report document map. For information on what a
document map is, see Chapter 6.

true

Zoom Sets the zoom value. You can use a number representing a percentage
or a string with standard values such as Page Width and Whole Page.

100

Section Specifies the page number of the report to display. 1