Inserting group totals in layouts
Accountants Enterprise only
To insert a group total in a layout
- Open the Reports Designer page for the report you want to edit. See Opening reports for advanced formatting or editing.
Click and drag each field that you want to total at the group level from the Available list of the Fields area to the appropriate position in the group footer area.
Group totals are most often displayed below the data for that item, so the text box is dropped immediately below the data field and its column headings. Aligning items within a layout is best done when all the items have been inserted.
- Click to select the field, then locate the Summary properties in the Properties area.
- Use the drop-down lists to enter the value shown below for each of the properties:
Property | Value | Purpose |
|---|---|---|
SummaryGroup | ghGroup | This property tallies the individual values and reports the total for the whole group. |
SummaryRunning | Group | This property tallies the group totals to provide a running total. |
SummaryType | SubTotal | This property determines the type of total and its availability for further summing in the report. |
You can only sum data that is numeric.