Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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