IPivotDimensionLevelPropertiesCommon.CollapseChildren

Syntax

CollapseChildren: TriState;

Description

The CollapseChildren property determines whether dimension(s) child elements will be collapsed on creating a table.

Comments

The property can be set to TriState.Undefined if the current parameters are obtained for heading or sidehead, and hierarchies of elements in different dimensions are in different states. If the property is set to TriState.OnOption, all hierarchies will be collapsed.

Example

Executing the example requires a form with the Button1 button, the UiErAnalyzer component named UiErAnalyzer1 and any visualizers, for which UiErAnalyzer1 is set as a data source.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    LHeader: IPivotHeader;
Begin
    Express := UiErAnalyzer1.ErAnalyzer;
    Pivot := Express.Pivot;
    LHeader := Pivot.LeftHeader;
    If Not LHeader.IsCollapseChildren Then
        LHeader.CollapseChildren := TriState.OnOption;
    End If;
End Sub Button1OnClick;

Clicking the button checks if there are expanded hierarchies of elements in dimensions located in the sidehead. If there are such dimensions, hierarchies of elements of all dimensions will be collapsed in the sidehead.