Export (0) Print
Expand All

Passing a Report Parameter Within a URL

You can pass report parameters to a report by including them in a URL. These URL parameters are not prefixed because they are passed directly to the report processing engine. For more about report parameters, see Running a Parameterized Report.

To set a report parameter within a URL, simply includethe parameter name, an equal sign (=), and the value of the parameter. The syntax is param=value. To pass a null value for a parameter, use ParameterName:isnull=true, for example, SalesOrderNumber:isnull=true.

ms155391.note(en-US,SQL.90).gifNote:
If your report contains a parameter that has a default value and the value of the Prompt property is false (that is, the Prompt User property is not selected in Report Manager), then you cannot pass a value for that parameter within a URL. This provides administrators an option for preventing end users from adding or modifying the values of certain parameters.

The following example uses the report parameter EmployeeID to render the specified report:

http://server/reportserver?/Sales/Northwest/Employee Sales Report&rs:Command=Render&EmployeeID=1234

Other Resources

URL Access

Help and Information

Getting SQL Server 2005 Assistance

Community Additions

ADD
Show:
© 2014 Microsoft