Data can be grouped onto different worksheets when the report is generated. In our worked example we will use this feature to put data from each borehole onto a different sheet.

To define a group simply click on the Group check box next to the field name as shown below.

Once the data has been grouped a new worksheet will be generated for each value in the group. This can be seen below when data is split by Location ID.

Grouping can be applied to number fields, date fields and short text fields. It cannot be applied to long text fields.

You can group by more than one field, although it is unlikely to group by more than 4 fields.

The order with which the sheets are returned when more than one group field is specified can be controlled using the Move Up and Move Down buttons on the group form. The group form can be accessed by clicking the Group icon on the ribbon.