Totalling and Subtotalling

---

Totals and sub-totals can be added to sections containing collections repeating sections). To do this, select the section you want to total, and access the Section Properties. Totalling options display on the Main tab in the Totals and subtotals section.

Click Total this section to add totals to the section, and Subtotal this section to also add subtotals to the section (Note: the remaining options in this section are not currently functional). When you select these options, total and subtotal sections will be inserted into your original section.

The Totals section always display at the base of the section and the Subtotals (if option selected) will be inserted between the collection and totals sections. Total sections are recognisable because they are surrounded by red lines. These sections can be selected the same way as any other click on section and it will highlight in blue), and fields may be added using the Available Fields Palette.

The Totals tab on the Available Fields Palette is only available if you are positioned on a totals section. You will be able to select total fields using the database fields that have been added to the main section, for example:

Note: It will not be applicable to add a total for all fields, but they are all available in this list (for example, it would not make sense to add a total for the item code). If you want to add a count to your total section - not a total value, but a count of records within the section (such as items or customers), you can add the Item Count property, available to select from the Others tab within the Available Fields Palette.

If, for example, you select field4 (quantity) as a total field and drag this into the subtotal section, the report will calculate quantity subtotals within the section. The totals will be using the class type of the repeating sections parent.

• Sorting

---