Udostępnij za pośrednictwem


Sort and Group Dialog Box (Report Builder)

Use the Sort dialog box to organize report data in ascending or descending order within groups and to specify page breaks between groups.

Sort Options

  • Select Group
    Select the group name by which you want to organize the report data.
  • Sort by
    Select the field on which you want to sort.
  • Ascending
    Choose this option if you want to sort from lowest to highest, for example, from 1 to 100 or A to Z.
  • Descending
    Choose this option if you want to sort from highest to lowest, for example, from 100 to 1 or Z to A.
  • Then by
    Select the next field on which you want to sort. This option appears when you have more than one field on which you can sort.

Page Break Options

  • Page breaks between groups
    Select to insert page breaks between groups within the report.
  • Also break before first group
    Choose this option to insert a page break before the first group.
  • Also break after last group
    Choose this option to insert a page break after the last group.
  • Also break before first group and after last group
    Choose this option to insert a page break before the first group and after the last group.

See Also

Other Resources

Grouping and Sorting Data (Report Builder)
Controlling Page Breaks, Headings, and Columns (Report Builder)
How to: Sort Data (Report Builder)
How to: Add or Remove a Page Break Between Groups (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance