Progress
Results User’s Guide
for Windows


Subtotals

If you use a sort order to create break groups within the report, you can calculate the subtotal for each break group. For information about sorting with break groups, see the "Sorting Records" section in Changing the Query Selection Criteria."

For example, a report that is sorted in ascending order by Cust-Num and descending order by Order-Num, contains two break groups: one for customers and one for orders. You can use either the break group associated with Cust-Num or the break group associated with Order-Num to create subtotals.

The following report contains a subtotal associated with the Order-Num break group to calculate the total price for all the items in each order:

The following report contains an additional subtotal based on the Cust-Num break group to calculate the total price of all the items each customer ordered. This subtotal includes all the items in all the orders for each customer:

As shown in this example, you can use any combination of subtotals for each break group.

You can create an aggregate field based on any database field and on the following types of calculated fields: Math, String Function, Numeric function, Date Function, and Logical Function.


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