Share via

NIB - Subtotal Element (RDL)

  • Article

[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