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)