Search results

Sorting

Sorting arrange the data in either ascending or descending order to present data in more readable formats. It can be used to sort the data in a data regions.

open-sort-dialog

Add Sorting

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

    choose-sort-fields

  2. Dataset fields are listed in the first drop-down list, choose the necessary field from the drop-down list or set an Expression.

    open-expression

  3. Sort Direction types are listed in the second drop-down list, choose a sort direction in the drop-down list.

    • Ascending sorts the data in A-Z order.

    • Descending sorts the data in Z-A order.

    add-field-to-sort

  4. Click OK.

  5. To add multiple sort expression, follow steps 1 - 4.

    addfield multiple sort

Set Expression

Follow steps 1 - 4, to add sort 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 sort expression, click and hold the icon in the left corner, and then drag the sort expression to higher or lower position.

reorder fields in sort

The position of dragged sort expression is shown as below:

after reorder fields in sort

Remove Sorting

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

delete-fields-sorting