Grouping Element (RDL)

  • Article

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