Progress
Report Builder
Tutorial


Creating a Balance Total Aggregate Field

You can create an aggregate field to display the total balance for the customers listed on each page.

Follow these steps to create the Page–Total aggregate field:

  1. Choose Calculations Aggregate Field. The Aggregate Fields dialog box appears:
  2. Report Builder automatically creates the GrSum1 aggregate field when it creates the instant layout for the report.

  3. Choose the New button. The New Aggregate dialog box appears:
  4. Type Page–Total in the Name fill-in field.
  5. Choose Total as the field type.
  6. Select Balance from the Field drop-down list. This instructs Report Builder to total the values of the Balance field.
  7. Select Per–page as the reset level. This tells Report Builder to reset the total to zero at the beginning of each page. The following dialog box shows the proper settings:
  8. Choose OK to return to the Aggregate Fields dialog box. Notice that Page–Total now appears in the list:
  9. Choose Close to return to the report layout.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095