Pro SQL Server 2012 Reporting Services

CHAPTER 9  RENDERING REPORTS FROM .NET APPLICATIONS

Credential Parameters

If, in previous versions of Reporting Services, you were using credential parameters to pass datasource

connection information, you will have to modify these reports to upgrade them to a SSRS 2012 server.

The credential parameters that passed username and password information to a report server for

rendering were stored in plain text in the browser cache. This was very insecure and this set of

parameters has been removed from SSRS 2012.

Report Viewer Web Part Commands

Report web part viewer commands are prefixed with rv: and are used to target the web part used to view

reports in SharePoint mode. You can use these parameters to control how the report and its controls are

displayed from the web part. You can also use these parameters to control how the report will be

rendered. You can see these parameters in Table 9.4.

Table 9-4. Web Part Commands

Parameter Description Supported Values

Toolbar Controls how the toolbar is displayed on the report

viewer web part

Full

Navigation

None

HeaderArea Controls how the header is displayed on the report

viewer web part

Full

BreadCrumbsOnly

None

DocMapAreaWidth Controls the pixel width of the document map Integer

AsynchRender Controls whether the report is rendered synchronously

or asynchronously. Using a true value will render

asynchronously.

Boolean

ParamMode Contr ols how the parameter prompt is displayed in the

report viewer web part

Full

Collapsed

Hidden

DocMapMode Controls how the document map is displayed in the

report viewer web part

Full

Collapsed

Hidden

DockToolBar Controls where the web part toolbar is docked on the

page

Top

Bottom

ToolBarItemsDisplayMode Contr ols which items are displayed in the web part’s

toolbar. This is a bitwise enumeration value of each of

the toolbar items. To show all items, use the value -1.

Integer from (-1) to

(2047)