Defining and Painting a Total Field

You can define a total format for each field in the report access order, except for the lowest level format. You can also define a report-level total. A report-level total lets you define totals for the entire report rather than for a field in the report access order.

You must define the report format before you can define a total format for the report. For more information, see Structuring a Report.

On the Report Format form, TotFmt identifies the total format window:

TotFmt: Employee.Job Code

To define and paint totals

  1. On the Database Structure-Program Structure form, select the task for which you want to define totals and press Define (F6).
  2. To define totals for a report with only one sort order, choose Totals.

    To define totals for a report with alternate orders, choose Alternate Order Totals. The Select Order window appears. Choose the order for which you want to define totals.

    The Total Structure Definition window appears. If the report has a detail format, it does not appear in the Total Structure Definition window because you cannot define totals for the detail format.

  3. In the Totals column, select Yes on each level for which you want to paint a total format.

    The lowest level format cannot have a total format unless the report has a detail format.

  4. Press OK.

    The Report Format form appears with a Totals Format for each level marked Yes in the Total Structure Definition window. Although the form also displays all Report Format and Summary Format windows, you can paint only in a Totals Format window.

  5. Press Shift+↓ to move the cursor to a Totals Format window.
  6. Paint the Totals Format. For instructions, see Painting Fields on a Report.
  7. Press OK twice.