Grouping & Sorting

Grouping & Sorting

Creating a Group

• Right-click on left margin of table and select Insert Group


• Select a field to group on or enter an expression


• Select any options (page break at start, page break at end, etc.) and click OK to
  create group


• SSRS doesn't automatically add the group field to the group header (the wizard does,
  though) but you can add it easily enough

Groups

• You can use Sorting tab of Grouping and Sorting Properties dialog to sort groups
  and detail with groups


• To edit group, right-click on left-hand margin of group header or footer and select
  Edit Group


• Groups can be nested many deep

Interactive Sorting (New for 2005)

• Lets users re-sort reports on columns that you pre-specify


• Right-click column header, select Properties, & click
  Interactive Sort tab