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

> ## Defining totals only reports

> This section describes how to define a Totals only report.

> | To combine records within a group so that just a summary (total) line appears for each group:

> 1. Define a report, as described in Chapter 3, " A Tour Through Results."

> 2. Specify the order for the records in the report. Be sure to place the field you want to use to group records as the last field in the order definition.

> 3. Select the Settings option, then select the Totals Only Report option. (You cannot select this option unless you have an order defined for the report.). This window appears:

> 4. Select ENABLE to define this report as a totals only report.

> A window similar to the following appears:

> The window on the left describes how this option works for different types of field information. The window on the right lists the fields in the reports. By default, Results— marks non-indexed, numeric (integer and decimal) fields as summary fields. It does not mark indexed fields because they are usually fields you do not summarize. For example, some common indexed fields are Cust-num and phone number; these are fields you normally do not summarize.

> If you mark character, date, or logical fields as summary fields, the system counts them. For example, if you mark the State field and there are two states in the group, Results places a 2 in the State field.

> 5. Select or deselect fields so that the fields you want to summarize are marked, or use the default settings.

> 6. Press GO to apply the settings.

> A few changes appear in the Reports window. For example, you might see this window:

> The dollar symbols ($) show you the fields that are marked as summary fields, and the Totals Only indicator tells you this report is a totals only report.

> 7. Run the report to your terminal and check the output to ensure that you get the results you expect.

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