User-Defined Parameter Definitions

The user-defined parameters are defined when setting up the input filter on the Report Data Process Details page. They must follow this syntax:

%PARM.<function>.<parameter>

Consider the following example using the filter And PRI.STATE in (%PARM.REPORT.STATE) and these parameters:

• REPORT, STATE, CA

• REPORT, STATE, OR

In this example, the generated SQL statement would include: And PRI.STATE IN ('CA','OR'). Below is an example of how you would use these user-defined parameters in the program:

&reportBatch.AddParamChar("REPORT", "STATE", "CA");
&amp_reportBatch.AddParamChar("REPORT", "STATE", "OR");