Set Value

Enter a value for the report parameter you selected in the Report Parameter Presets dialog box and click OK. For example, if your report parameter is ZIP_CODE<, you could enter 40000 to print all zip codes that are less than 40000.

Note:

If your report parameter uses an IN or NOT IN qualifier, use quotes around the values you specify. For example, to limit the jobs printed to accounting and sales you would enter:

'ACCOUNTING', 'SALES'

to create the report parameter, JOB IN (‘ACCOUNTING’, ‘SALES’). SQR Production Reporting Studio automatically creates the parentheses.

If your report parameter uses a LIKE or NOT LIKE qualifier, use quotes and a wildcard character with the value you specify. For example, in Oracle you would enter:

'SALES%'

to create the report parameter, JOB LIKE ‘SALES%’