Share via


How to: Add a Group to a Table (Report Designer)

To add a group to a table

  1. In Layout view, click the table so that column and row handles appear above and next to the table.

  2. Right-click the row handle where you want to insert the group and then click Insert Group.

    Note

    The location of the new group row is determined by the row that is selected. Selecting a detail row places the new group just outside the detail row. Selecting an existing group row places the new group inside the selected group row.

  3. On the General tab, do the following:

    • In Name, type the name of the group.
    • In Group on, type or select the expressions by which to group the data.
    • (Optional) In Document map label, type or select an expression to use as a document map label.
    • (Optional) If this group is a recursive hierarchy, for Parent group, type or select an expression to use as the recursive group parent.
    • (Optional) Click Page break at start or Page break at end to place a page break at the beginning or end of each group instance.
    • (Optional) Click Include group header or Include group footer to place a header or footer for the group in the table.
    • (Optional) Click Repeat group header or Repeat group footer to repeat the group header or footer on each page in which the table appears.
  4. (Optional) On the Sorting tab, select or type expressions on which to sort the data within the group.

  5. (Optional) On the Filters tab, select or type expressions by which to filter the data within the group.

  6. (Optional) On the Visibility tab, select the visibility options for the item. For more information about visibility, see Hiding Report Items.

  7. (Optional) On the Data Output tab, select the data output options for the item.

See Also

Concepts

Working with Table Data Regions
Grouping Data in a Report
Report Designer How-to Topics

Other Resources

Report Designer F1 Help

Help and Information

Getting SQL Server 2005 Assistance