Partager via


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 Exécution d'un rapport paramétrable.

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(fr-fr,SQL.90).gifRemarque :
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

Voir aussi

Autres ressources

URL Access

Aide et Informations

Assistance sur SQL Server 2005