Textbox Properties - Interactive Sort (Visual Studio Report Designer)
Use the Interactive Sort tab of the Textbox Properties dialog box to define sort columns for rows of data that appear in a table or matrix.
Options
- 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.
See Also
Reference
Textbox Properties Dialog Box - General Tab (Visual Studio Report Designer)
Concepts
Adding Interactivity, Visibility, and Navigation to a Report (Visual Studio Report Designer)
Adding Data Regions to a Report (Visual Studio Report Designer)
Sorting Data in a Report (Visual Studio Report Designer)
ReportViewer Controls (Visual Studio)
ReportViewer Web Server and Windows Forms Controls