Kbase P76117: How to use IN-LIST and IN-RANGE in a Report Engine filter override, RB-FILTER.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/07/2004 |
|
Status: Unverified
GOAL:
How to use IN-LIST and IN-RANGE in a Report Engine filter override, RB-FILTER.
FIX:
When IN-LIST or IN-RANGE are used in a filter override they are treated as functions, the same as when they are used in calculated fields.
For example, IN-LIST(cust-num,1,2,3).
When they are used in a filter within Report Builder they are treated
as an operator.
For example, cust-num IN-LIST 1,2,3.
Example of IN-LIST in RB-FILTER:
"O", /* RB-INCLUDE-RECORDS */
"IN-LIST(cust-num,1,2,3) > 0", /* RB-FILTER */
Example of IN-RANGE in RB-FILTER:
"O", /* RB-INCLUDE-RECORDS */
"IN-RANGE(cust-num,1,3)", /* RB-FILTER */