NIB - Subtotal Element (RDL)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Defines a subtotal column or row to be included in the matrix.

Syntax

<DynamicColumns> <!-- or DynamicRows-->
    ...
    <Subtotal>
        < ReportItems >...</ReportItems>
        <Style>...</Style>
        <Position >...</Position>
        <DataElementName>...</DataElementName>
        <DataElementOutput>...</DataElementOutput>
    </Subtotal>
    ...
</DynamicColumns> <!-- or /DynamicRows -->

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-1: Optional element that can occur once or not at all.

Element Relationships

Relationship	Element
Parent elements	DynamicColumns, DynamicRows
Child elements	DataElementName, DataElementOutput, Position, ReportItems, Style

Remarks

If a matrix cell contains an aggregate that specifies a scope that is inside the current scope, the scope will default to the current scope instead. For example, if a matrix cell that is placed in the Category grouping contains the expression =Sum(Fields!Sales.Value, "SubCategory"), the expression will evaluate as =Sum(Fields!Sales.Value, "Category"), because the SubCategory grouping scope is contained within the Category grouping scope.

See Also

Reference

Report Definition XML Elements

Help and Information

Getting SQL Server 'Katmai' Assistance