Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

> ## Creating totals only reports

> This section describes how to create a totals only report. You can use the Totals Only Report option to display summary information about groups of records.

> To use the Totals Only Report option, you must have order criteria defined for the report. Then you can summarize the report on the last field in the order list so that a new line appears each time the order field value changes. For example, if you order your customer information by state, then define the report as a totals only report, you receive one line of information for each customer.

> Each time the value changes, Results:

> - Creates a subtotal for each numeric field. For example, a subtotal for all numeric fields appears each time the value of the last order field changes.

> - Displays the field value in the last record if the field is nonnumeric. For example, if you include the customer name, you see the name of the last customer in each state.

> - Displays the total number of records in each group if you choose to summarize a non-numeric field.

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