Share via


Text Box Properties Dialog Box, Interactive Sort (Report Builder 2.0)

Select Interactive Sort on the Text Box Properties dialog boxto define interactive sort options for the selected text box.

Options

  • Enable interactive sort on this text box
    Select this option to provide end-user sorting on a published report. This puts up and down arrows on this text box. When clicked, a sort action is performed on the data specified by the Sort this data selection.

  • Detail rows
    Choose this option to enable sorting on the innermost group of the scope that the text box is within. .

  • Groups
    Select to specify the group to which the interactive sort applies.

  • Sort by
    Specify the sort value. For example, an Employee Name column might be sorted by last name or by employee ID number. You can select a field from the drop-down list or click the Expression (fx) button to type an expression.

  • Also apply this sort to other groups and data regions
    This option is displayed when the Detail rows option is selected. Choose this option when you want to apply the sort options you selected to another group or data region.

  • Apply this sort to other groups and data regions within
    This option is displayed when the Groups option is selected. Choose this option when you want to apply the sort options you selected to the report dataset.