Progress
Results User’s Guide
for Windows


Sort Order and Break Groups

When you use a field to sort records in a query, Results automatically creates a break group based on the field you used to sort the records. A break group is a set of records that have a common value in a certain database field. The last example used the Cust-Num and Order-Num fields to retrieve the orders for each customer, starting with the most recent order. Thus it contains two break groups: one for Cust-Num and one for Order-Num.

Break groups are useful because they allow you to perform calculations on a subset of records in the query. For example, you can count the number of orders for each individual customer or even calculate the total Extended-Price for the items each customer ordered. See the "Creating Aggregate Totals and Subtotals" section in "Analyzing Data," for more information about performing calculations on break groups.


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