Pro SQL Server 2012 Reporting Services

CHAPTER 9  RENDERING REPORTS FROM .NET APPLICATIONS

Parameter Description Supported Values

Prefix When used, indicates that the following parameter is a

command to the server itself versus a report parameter

rc: Rendering control

rs: Report server command

dsu: User

dsp: Password

Param Specifies the command parameter name when used with a

prefix; otherwise, specifies a report parameter name

None

Value Specifies the value of the parameter None

We’ll now walk you through the steps of building a URL to access the Employee Service Cost report.

URL Report Access Path Format

As indicated in the previous section, the path to access the appropriate report starts with the name of the

report server itself; in this case, we will use http://localhost and use an SSRS installation that is in

native mode. Following that is the name of the SSRS 2012 virtual root folder (such as /reportserver,

which is the default folder during installation).

 Note The /reports virtual root folder is mapped to the Report Manager application that ships with SSRS 2012. If

you navigate to this URL, you’ll find that it lists the folders and the reports within the folders that are on your report

server through Report Manager.

You then add? to the path to let SSRS 2012 know that everything following the URL is a parameter.

Next is the optional path information, where you can specify any subfolder within the base folder that

you use to organize your reports, such as /Pro_SSRS/Chapter_9. Finally, you have the name of the actual

report, such as EmployeeServiceCost.

So, in this example, the full path to access the Employee Service Cost report is as follows:

http://localhost/reportserver?/Pro_SSRS/Chapter_9/EmployeeServiceCost

We’ll now cover the section of the URL where you specify any necessary parameters.

URL Parameters and Prefixes

You now need to pass the appropriate parameters to the report. You’re interested in several categories of

parameters:

Report parameters (no prefix): These parameters are supplied to the report’s

underlying queries and are used as filters for the information as it’s rendered.

Thus, they control exactly which data the report displays.