Group Report Data

Grouping sorts data even further by grouping records together that have the same value or range. For example, grouping by priority.

  1. Open the Report Designer.
  2. Click the table and click the row icon to the left of the row to select the entire row.

  1. Right-click the row icon.
  2. Click Group and Insert Group.
  3. In the Groups panel, select the Table 1.

  1. In the Properties tab, enter the Name for the group.

NOTE: The name cannot have spaces, but underscores or camel case could be used instead.

  1. Click Add item next to the Group Expressions field.
  2. Click the Data Binding field to the right of the field and click the field you'd like to sort the group by even further.

  1. Add a Page break after each group section if desired.
  2. Additional filters can be applied to the group.
  3. A Sort Expression can be added to sort the group by ascending or descending as well. For example, priority descending.
  4. Select the header row and click the one to the left of the row.

  1. Click the three dots icon and select the header field.

  1. Click Save.
  2. Click Preview to see if the report looks as expected. See Preview a Report for more information.