When there is one or more break groups in the report, and the report is offered in interactive mode, the Group Total Context Menu is available for you to change the aggregation type for each column, edit the text, and change the font face, size, style, color, text alignment, and background color for the entire group totals area.
To access the Group Total Context Menu, move your cursor at any of the aggregation data for the columns at the end of a break group. Even when there is no aggregation data for a column and the group totals area appears blank, you can still mouse over that area to bring up the Group Total Context Menu.
If there are multiple levels of break groups in the report, the level of group totals where you activate the Group Total Context Menu is the level your changes will be applied to.
With the menu items, you can perform the following actions on this level of break group:
![]() |
The color scheme you see may vary, but menu items provided and their functionality are the same. |
![]() |
There is not an "undo" menu item through the context menu. Simply continue the use of the context menu until you reach your desired report layout. |
You can dynamically set the aggregation type to either sum, count, average, minimum, maximum, or none. Changes will affect the group totals for only the column and the level of break group where you activate the Group Total Context Menu.
When you select Edit Text from the Group Total Context Menu, the group total for that column will become an editable text box:
The <value/>
tag is used to display the aggregation value.
You can add text around the tag. For example, if you add "total cost: $"
to the front of the <value/>
tag:
total cost: $<value/>
the group total will become something like the following:
total cost: $308.4 514 1,028
Once you press Enter or click anywhere else in the report, the change will be applied.
![]() |
If you remove the |
![]() |
If you make an error while you are typing, you can revert back to the previous setting by using the Ctrl-Z key shortcut or by pressing the Escape key. |
![]() |
When entering Japanese characters, the keyboard input needs to be set to either Hiragana, full-width Katakana, or full-width ascii. |
When you select Style... from the Group Total Context Menu, the Report Style dialog box will pop up. For details on editing group headers and the Report Style dialog box, see Specifying Font Face, Size, Style, Color, Text Alignment, and Background Colors.