Поделиться через


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.

ms155391.note(ru-ru,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

См. также

Другие ресурсы

URL Access

Справка и поддержка

Получение помощи по SQL Server 2005