Report Totals

What section are you putting your totals in?

You can always look at a report that is working in a similar way that you would like to see how it was done there.

ie. Accounts Receivable Aging

CREATETOTALS
Use this function to maintain totals for a variable in the same way as totals are maintained for fields by using the TotalFields property.

CREATETOTALS(Var1 [, Var2] ,...)
Var1, Var2, ...

Data type: decimal

Comments
Just like the TotalFields property, CREATETOTALS causes group and grand totals to be maintained. The totals can be printed by placing controls that have the variable or variables that are the arguments of CREATETOTALS as their source expressions in the appropriate sections: the group totals are printed in GroupFooter sections, and the grand totals are printed in Footer sections.

Example
To have the system maintain totals for the two variables Amount and Quantity, use CREATETOTALS like this:

CurrReport.CREATEOTALS(Amount, Quantity);

---

TotalFields

Use this property to indicate the fields of a data item for which the system should maintain totals. If this property is used in conjunction with the GroupTotalFields, totals can be maintained for both the groups that are defined and all records that are output; if used by itself, TotalFields will maintain totals for all records.

Applies to Data items

Settings
A comma-separated list of field names. The fields can be selected by using the assist-edit function in the Value field of this property.

Comments
The totals are printed by placing controls that have the fields that are indicated in TotalFields as their source expressions in a Footer, GroupFooter or TransFooter section of the data item.