Help Home

Using the Group Total Context Menu


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:

Note

The color scheme you see may vary, but menu items provided and their functionality are the same.

Note

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.

Change the Aggregation Type

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.

Edit Text for Break Group Totals

When you select Edit Text from the Group Total Context Menu, the group total for that column will become an editable text box:

This image shows the result when you choose to edit text on a group total. The group total area becomes an editable textbox.

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.

Note

If you remove the <value/> tag, the aggregation value will not appear. You can get back the value by reselecting an aggregation type form the Group Total Context Menu.

Note

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.

Note

When entering Japanese characters, the keyboard input needs to be set to either Hiragana, full-width Katakana, or full-width ascii.

Specify Font Face, Size, Style, Color, Text Alignment, and Background Colors

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.


Related Topics: