Create a nested composite group

A composite group may contain any type of report item, even other composite groups. This way it is possible to create nested groups where, for example, the outer group is repeated on the sample type, and the inner group is repeated on the sample name. The following procedure shows you how to create a nested group.

  1. Create and save a composite group with sample information that is repeated on the sample name.

  2. Add the field Sample_Type to your template. Place it above the previously created composite group.

  3. Select both the Sample_Type field and the previously prepared composite group.

  4. Create a new composite group containing the two selected items.

  5. Repeat the new composite group on Sample_Type.

  6. If you generate the report, the different sample types are shown as headings. Under each sample type, the respective samples are listed.

Nested composite groups correlate to "lists in lists" in Microsoft Business Intelligence Studio.

See Also