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.

附註：
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

請參閱

其他資源

URL Access

說明及資訊

取得 SQL Server 2005 協助