Kbase 16404: Report Builder - Use IN-LIST and IN-RANGE in filter override
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Report Builder - Use IN-LIST and IN-RANGE in filter override
This knowledgebase describes how to use IN-LIST and IN-RANGE
in a Report Engine filter override, RB-FILTER.
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 */
Progress Software Technical Support Note # 16404