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:

  1. Choose Database Filter. The Insert Filter Condition dialog box appears:
  2. Select Order–Date from the Field drop-down list.
  3. Select IN–RANGE from the Comparison drop-down list.
  4. Type 1/1/95, 6/30/95 in the Compared To field.
  5. Choose OK to create the condition. The Filter dialog box appears.
  6. Choose OK to save the filter and return to the report layout.
  7. 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