Progress
Report Builder
Tutorial
Defining the Filter
This report displays the sales and commission information for 1/1/95 to 6/30/95. To limit the data to those six months, you must define a filter with one filter condition.
Follow these steps to define a filter condition:
- Choose Database
Filter. The Insert Filter Condition dialog box appears:
![]()
- Select Order–Date from the Field drop-down list.
- Select IN–RANGE from the Comparison drop-down list.
- Type 1/1/95, 6/30/95 in the Compared To field.
- Choose OK to create the condition. The Filter dialog box appears.
- Choose OK to save the filter and return to the report layout.
The complete condition is Order–Date INRANGE 1/1/95, 6/30/95. When Report Builder processes the filter, it will only display orders and commission information for the specified six-month period.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |