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 运行参数化报表.
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.
.gif "ms155391.note(zh-cn,SQL.90).gif") 注意： |
|---|
| 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. |
Example
The following example uses the report parameter EmployeeID to render the specified report:
https://server/reportserver?/Sales/Northwest/Employee Sales Report&rs:Command=Render&EmployeeID=1234