Online Help | Desktop App

Grouping

You can group records by one column, or by a series of columns. Alloy Navigator Express offers the following tools for grouping records:

NOTE: Once you group records by a column, they get automatically sorted by this column.

When the records are grouped by multiple columns, you can change the order of grouping levels either by using the Group Panel or the Grouping tab of the Customize View window.

To group records by using the grid pop-up menu:

  1. Right-click the heading of the first column you want to group records by and choose Group > Group by This Column from the pop-up menu.

  2. If you want to group by more than one column (create subgroups), repeat the first step for every column you want to group records by. Each next grouping creates subgroups inside previously created groups.

To group records using the Group Panel:

  1. Make sure the Group Panel is shown. For details, see Showing and hiding the Group Panel.

  2. Drag the heading of the first column you want to group records by to the Group Panel.

  3. If you want to group by more than one column (create subgroups), drag the heading of the next column to group by to the Group Panel. Repeat this action to create as many subgroups as you need.

To group records using the Grouping tab of the Customize View window:

  1. Right-click anywhere in the grid and choose Customize View from the pop-up menu.

  2. In the Customize View window, click the Grouping tab.

  3. In the Available Fields pane, double-click the field by which you want to group records.

  4. If you want to organize multi-level grouping, repeat Step 3 for each field by which you want to group the records.

  5. Click OK.

To change the order of grouping levels on the Group Panel:

  1. Make sure the Group Panel is shown. For details, see Showing and hiding the Group Panel.

  2. The order of columns in the Group Panel (from left to right) defines the order of the grouping levels. Using drag-and-drop operations, place the columns in the desired order.

  3. Click OK.

To change the order of grouping levels on the Grouping tab:

  1. Right-click anywhere in the grid and choose Customize View from the pop-up menu.

  2. In the Customize View window, click the Grouping tab.

  3. The order of columns in the Group by These Fields pane defines the order of the grouping levels. Place the columns in the desired positions by using the Move Up and Move Down buttons.

  4. Click OK.