Grouping Element (RDL)

Defines how the data is grouped.

Syntax

<List> Name="..."> <!-- or <DynamicColumns>, <DynamicRows>, <TableGroup>, <Details>, <DynamicSeries>, <DynamicCategories> -->
    ...
        <Grouping Name="...">
            <Label>...</Label>
            <GroupExpressions>...</GroupExpressions>
           <PageBreakAtStart>...</PageBreakAtStart>
            <PageBreakAtEnd>...</PageBreakAtEnd>
            <Custom>...</Custom>
            <Filters>...</Filters>
            <Parent>...</Parent>
            <DataElementName>...</DataElementName>
            <DataCollectionName>...</DataCollectionName>
            <DataElementOutput>...</DataElementOutput>
        </Grouping>
       ...
</List> <!-- or /DynamicColumns, /DynamicRows, /TableGroup, /Details, /DynamicSeries, /DynamicCategories -->

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality (when used as a child of List or Details)	0-1: Optional element that occurs once or not at all.
Cardinality (when used as a child of DynamicColumns, DynamicRows, DynamicCategories, DynamicSeries, or TableGroup)	1-1: Required element that occurs once and only once.

Element Attributes

Attribute	Type	Description
Name	String	Name of the grouping.

Element Relationships

Relationship	Element
Parent elements	Details, DynamicCategories, DynamicColumns, DynamicRows, DynamicSeries, List, TableGroup
Child elements	Custom, DataCollectionName, DataElementName, DataElementOutput, Filters, GroupExpressions, Label, PageBreakAtEnd, PageBreakAtStart, Parent

Remarks

The value of the Name attribute of the Grouping element must not be set to the name of a dataset, data region, or other grouping in the report.

Page breaks in dynamic series, dynamic categories, and dynamic columns are not allowed.

See Also

Reference

Report Definition XML Elements

Help and Information

Getting SQL Server 2005 Assistance