Progress
Report Builder
User’s Guide
Creating a Filter
You create a filter by specifying one or more filter conditions. Follow these steps to create a filter:
- Choose Database
Filter. If you have already defined a filter condition for this report, the Filter dialog box appears:
![]()
- Choose the Insert button.
If this is the first filter condition you are defining for the report, the Insert Filter Condition dialog box appears:
![]()
- If the filter has more than one condition, use the left parenthesis option to specify the beginning of a condition group. Parentheses indicate the order in which Report Builder evaluates AND and OR in a filter condition. Report Builder evaluates operators within parentheses first, from the innermost parentheses outward. If you do not use parentheses, Report Builder evaluates AND operators before OR operators.
- Select a field from the Field drop-down list. This is the field by which Report Builder evaluates the criteria. You can use most calculated fields, some aggregate fields, and any of the fields defined for the tables used in the report.
- Select an operator from the Comparison drop-down list. The operator defines the relationship by which Report Builder evaluates the condition.
Not all of the operators are available for all fields. Report Builder enables different operators depending on the condition field type.
- Specify the value to which Report Builder compares the condition field. See the "Filtering Basics" section for a complete description of the valid comparison values.
- Specify AND or OR for multiple conditions. AND specifies that records must meet all the criteria established in all the conditions. OR specifies that records must meet the criteria for at least one of the conditions to be included in the report.
- If you used a left parenthesis in an earlier filter condition, use the right parenthesis to specify the end of a condition group.
- Choose NOT if you want to reverse the result of the comparison.
- Choose OK to create the filter. The Filter dialog box appears. It displays the newly created filter.
- Choose Verify to check the filter syntax.
- Choose OK to return to the report layout.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |