Designating a field to be totaled

ReportWriter can automatically total any numeric field (decimal, implied-decimal, or integer).

1.

Highlight the field in the Print Fields list.

2.

Select Field functions > Total field.

This entry is a toggle: select Total field again to turn the totaling function off.

When a field is going to be totaled, it is underscored by a line of asterisks in the report layout window, and a letter T is displayed in the FLAGS column for that field in the Print Fields list.

For our example, we’ll designate sales year-to-date as a field to be totaled. (See figure 1.)

1. Designating a field to be totaled.

For information on generating subtotals, see Setting a report break for a sort field.

Every report that you generate contains a report summary line. When the report does not contain fields being totaled, the report summary line contains the following:

• The report description
• The report count (the number of records included in the report)

When one or more fields is being totaled, the report summary line contains the following:

• The report description
• The word “total”
• The report count in parentheses
• The total amounts

This line is sometimes referred to as the report total or grand total line.