Release 10.1A: OpenEdge Reporting:
Query/Results 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. See "Sorting records" section for information about sorting with break groups.”

> 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.

> Figure 6–12 shows a report that contains a subtotal associated with the Order-Num break group to calculate the total price for all the items in each order.

> Figure 6–12: Subtotals - example one

> The report presented in Figure 6–13 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.

> Figure 6–13: Subtotals - example two

> 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095