Textbox Properties (Interactive Sort Tab, Report Designer)
- Add an interactive sort action to this textbox
Select this option to provide end-user sorting on a published report. Selecting this option places up and down arrows on column headings. When clicked, a sort action is performed on the result set.
- Sort expression
Specify the sort value based on the data contained in the column (for example, an Employee Name column might be sorted according to last names). You can select a field from the drop-down list or type an expression. Required.
- Data region or grouping to sort
Specify the result set to sort on. You can choose which data region or group to sort on.
- Current scope
Choose this option to enable sorting on the repeated rows in the data region that contains the sort item.
- Choose data region or grouping
Choose this option to select a specific data region or group (for example, if you want to sort additional data regions or data regions other than the one that contains the sort item).
- Evaluate sort expression in this scope
Specify which data regions or groups are sorted. Setting these options are useful if you are targeting a specific data region and you want to further specify where sorting occurs within that data region.
- Detail scope
Choose this option to sort only the repeated rows of the data region you selected.
- Data region or grouping
Choose this option to select a specific data region or group to sort on.