ExpressView: Grouping (v2021.1+)

Data may be organized in up to seven hierarchical groups. In addition to dragging-and-dropping fields to the canvas as described in the ExpressView: Introduction article, groups can be manipulated with the column menu.

Groups nest inside of each other and establish a “for each” hierarchy. In the example below, for each product category, all of the products will be listed.

Groups may be nested or layered together. In the example below, to see all of the model numbers for each manufacturer for each product category, two groups are needed: one on the category and one on the manufacturer. Since each manufacturer may have products in many categories, manufacturer should be the left-most or least-specific group. The product category will be nested inside of the manufacturer group so that for each manufacturer, all of the applicable categories and products in those categories are listed.

Adding Groups

To create the first group on an ExpressView, drag a field from the Data Objects pane to the “Add Group” drop zone on the canvas.

To change a detail field to a group, either drag-and-drop the detail field column to a Group drop zone (i.e. the Add Group zone or one of the drop zones on an existing Group column) or use the Column Menu:

1. Open the Column Menu by either clicking on the Column Menu  icon or right-clicking on the column.
2. Click  Group By This. The column will be added as the right-most (most-specific) group.

Adding a Group will automatically add an Ascending Sort on that column. See the ExpressView: Sorting (v2021.1+) article for more information.

Changing Group Order

As the order of Groups is changed, they will be promoted (less specific) as they move left or be demoted (more specific) as they move right.

Groups may be re-ordered by simply dragging-and-dropping them from one Group drop zone to another, or by using the Column Menu:

1. Open the Column Menu by either clicking on the Column Menu  icon or right-clicking on the column.
2. Click  Promote Group to promote a group to the left or  Demote Group to demote a group to the right.

Note

Dragging a group to a drop zone on a detail field column will ungroup the column and change it back to a detail field.

Removing Groups

To ungroup a column, either:

• drag-and drop it off of the canvas,
• drag-and-drop it over a detail field column’s drop zone (to change the group to a detail field),
• or use the Column Menu:
  1. Open the Column Menu by either clicking on the Column Menu  icon or right-clicking on the column.
  2. Do one of the following:
     • Click  Ungroup. The column will be converted to the left-most detail field column on the report.
     • Click  Remove Field to remove the column entirely.