Report Server query_string Parameters

There are several parameters that you can use to control how the Reporting Services run your Report requests. You include these in the report_query Innovator Report Item property, which the client then uses to form query_string for the ReportServer request.

Named Parameters can be passed into the SELECT SQL query. For example:

np:last_name=Kohl

They would map the Kohl value to the @last_name Named Parameter in the SELECT SQL:

SELECT * FROM [USER] WHERE last_name=@last_name

Use the Format parameter to control the format the Report is rendered:

rs:Format=XML

rs:Format=PDF

rs:Format=HTML4.0

rs:Format=MHTML

rs:Format=EXCEL

rs:Format=Word

Use the Zoom parameter to control the zoom:

rc:Zoom=100

rc:Zoom=% zoom as integer

rc:Zoom=Page Width

rc:Zoom=Whole Page

The default Folder where Reporting Services Reports are deployed is in Innovator Reports; however, you may deploy the Reports in other Folders, and you specify this using this Parameter:

irs:Folder=Your Folder Name

The Aras Innovator client automatically appends the Parameter to specify the Report to run on query_string, which is the name of the Innovator Report Item. However, if you run reports programmatically, you may need to set this directly yourself:

irs:Report=Your Report Name