Standalone Report Designer
Search results
Suggest a FeaturePDF

Grouping

Grouping can be used to organize and group data in data regions by a field value or expression value.

open-group-dialog

Add Grouping

  1. To add a group expression, Click on the Add icon.

    choose-group-fields

  2. Based on the dataset assigned to the data region, dataset fields will be listed in this drop-down or else click on the square icon to set an Expression.

    open-expression

  3. Click OK.

  4. To add multiple group expression, follow steps 1 - 3.

    addfield multiple group

Set Expression

Follow steps 1 - 3, to add group expression.

  1. To edit/create an expression, click on the square icon and select Expression.

    expression-icon

  2. Expression dialog will be open as shown below, Refer Expression section for better understanding with the following sections.

    open-expression

  3. The icon will be indicated in Black color, if the expression is applied to the dataset field. set-expression

Reset Expression

  1. To reset an expression, click on the square icon and select Reset. Select reset expression

  2. The icon will be indicated in White color, after reset action. After reset expression

Reordering

To change the order of an group expression, click and hold the icon in the left corner, and then drag the group expression to higher or lower position.

reorder fields in group

The position of dragged group expression is shown as below:

after reorder fields in group

Remove Grouping

Click Delete icon in the right corner to remove the respective group expression.

delete-fields-grouping