This option from the Report program editing menu allows you to specify a formula to be used in determining whether a record is to be selected for processing on the report (or export or delete). The default value is 'ALL'. You have 5 lines for entering the formula. See Section 4 for the rules for specifying a formula.
You can set up any valid formula using the operators and functions described in Section 4. The system accepts field names in either upper or lower case, but field values for C, M, P or U type fields must be in the appropriate form and enclosed within single or double quotation marks.
An error message is displayed if any aspect of the formula is incorrect or non-implementable. You should refer to field names in full, that is:
<table_name>.<table_role>.<field_name>.<field_role>
Alternatively, the field itself can be referred to as $ and another field in the report can be referred to as #4, where 4 is the field number within the report.
Note
Any field used in a formula must have been previously selected during field processing, whether or not you wish to print its values in the report.