Exago Logo
Search
Generic filters
Exact matches only

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.

AYBotH1v5j.pngPH3fN48dtA.png
ExpressView with two detail fields (left) and after adding CategoryName as a group (right). Note the two products grouped under the Beverages and Produce categories.

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.

XmE7MJOsNd.png
kbf7weC4Uf.png
An ExpressView with all columns as data fields (top) then with three data fields and two nested groups (bottom)

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.

firefox_puw4rYiOiJ.png

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 MoreOptions_Black.png icon or right-clicking on the column.
  2. Click MenuGroup.png 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 MoreOptions_Black.png icon or right-clicking on the column.
  2. Click PageUp.png Promote Group to promote a group to the left or PageDown.png 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 MoreOptions_Black.png icon or right-clicking on the column.
    2. Do one of the following:
      • Click MenuGroup.png Ungroup. The column will be converted to the left-most detail field column on the report.
      • Click CloseButton.png Remove Field to remove the column entirely.
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents