Progress
Report Builder
Tutorial
Inserting the Aggregate Fields on the Report Layout
Now that you have created the column headings, you are ready to insert the aggregate fields that compute the values for each column on the report layout. Because the default format for the aggregate fields you created is nine digits, which is too wide to fit on this layout, you must also change the format for all nine aggregate total fields to eight digits.
Follow these steps to insert the aggregate fields on the report layout:
- Insert the following fields on the group footer band line under the corresponding column headings:
- Insert the following fields on the second summary band line under the corresponding column headings:
- Select all the fields you inserted in Steps 1 and 2, except Grand–Total–Sales.
- Choose Properties
Format. The Format dialog box appears:
![]()
- Change the Total Number of Digits to 8, then choose OK. Report Builder changes the display format for all the selected fields and returns you to the report layout.
The following figure shows the right side of the report layout with the smaller format for all the aggregate fields:
![]()
Notice that there is more space between all the fields.
- Move the aggregate fields so that their right edges align with the right edges of the column headings.
- Draw a line above the ARM–All–Total.
- Copy the line and paste it above each field on the second summary band line.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |