Progress
Report Builder
Tutorial


Creating Fields to Total the Sales of All Items for Each Representative

Now you are ready to create the fields that calculate the total of all sales for each sales representative or, in other words, the total for each column.

Follow these steps to create an aggregate field for each sales representative:

  1. Create an aggregate field, ARM–All–Total, using the settings listed in the following table:
  2. Option
    Setting
    Type
    Total
    Field
    ARM–Sales
    Reset
    No–reset
    Accumulation
    Every Composite
    Processing
    Final Pass

    These settings instruct Report Builder to add all the values of ARM–Sales to calculate the total of all the items ARM sold.

  3. Create aggregate fields for each of the remaining sales representatives with the appropriate field, then return to the report layout. The remaining initials are BKO, JCO, MAR, MTW, PAM, PMB, SLA, and SMT.

The following Aggregate Fields dialog box shows the complete list of sales representative all total fields.

Make sure that you created all nine aggregate fields.


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