Textbox Properties (Interactive Sort Tab, Report Designer)

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

Report Designer F1 Help

Other Resources

Adding a Text Box
Sorting Data in a Report

Help and Information

Getting SQL Server 2005 Assistance