Switching Groups

Owned by DATABASICS, Inc.
Last updated: Sept 23, 2021

In the Ad Hoc Editor, the   icon lets you change how the groups are displayed. Depending on the type of report you are
viewing, the behavior varies:

  • Crosstabs: Moves the row groups to column groups and vice versa. This action is also referred to as pivoting. This option is only available for crosstabs that have both a column group and a row group.
  • Charts: Displays the alternate group. This option is only available for charts that have a column group. When multiple row or column groups are defined, the Chart tab displays the outermost group.
  • Tables: Displays the alternate group. This option is only available for tables that have a column group. When multiple row or column groups are defined, the Table tab displays the first group in the set (the outermost group).

By default, a table or chart is grouped by the column group; click   to group it by the row group.

Note: For this feature to be available for tables and charts, the report must be edited as a Crosstab to add a column group. Otherwise, there is no alternate group to switch to. When you design a table or chart and then view the Crosstab tab, you only have a row group defined. Drag a field into the column group to complete the crosstab.

2024 DATABASICS, Inc