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