Passing a Report Parameter Within a URL
SQL Server 2005
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.
Note: |
|---|
| 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. |
Note: