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:
| Parameter 1 | Parameter 2 | Parameter 3 |
|---|---|---|
|
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");
&_reportBatch.AddParamChar("REPORT", "STATE", "OR");