Progress
Results User’s Guide
for Windows
Using a Totals-Only Summary
In the Report and Export Views, Totals-Only Summary provides a quick way to calculate and display the combined value of a column of data for a specific break group. For more information, see the "Sorting Records" section in Changing the Query Selection Criteria."
The following example shows a query that does not use Totals Only Summary. In this example, the query displays the orders for each customer. The query uses the Cust-Num field to sort the orders for each customer in ascending order. Thus, it contains one break group-a break group for customers:
![]()
Since the query contains a break group based on the Cust-Num field, you can use Totals Only Summary to calculate and display the combined value of the Extended-Price field for each set of customer orders.
![]()
When you use Totals Only Summary, Results summarizes the information and displays one record for each group containing the total for the group. Note that when you use Totals Only Summary the Export view, Results displays the preceding records in the group in addition to the record containing the total.
Follow these steps to use Totals Only Summary.
- Verify that you have at least one break group. If you have more than one break group, Total Only Summary automatically uses the break group based on the last field in your sort list to perform the total.
- Choose Options
Totals Only Summary. The Totals Only Summary dialog box appears.
![]()
- Select one or more fields to total, then choose OK.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |