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

To add a group to a list

  1. In Layout view, right-click the list, and then click Properties.

  2. On the General tab, click Edit details group. This opens the Details Grouping dialog box.

  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.
  4. (Optional) On the Filters tab, select or type expressions by which to filter the data within the group.

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

  6. (Optional) On the Data Output tab, select the data output options for the item, and then click OK.

See Also

Concepts

Working with List 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