Subtotal Element (RDL)

  • Article

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 2005 Assistance