ChildrenBeforeParents: TriState;
The ChildrenBeforeParents property determines whether to place child elements of hierarchy are located before parent ones.
To get whether child elements of hierarchy are placed before parent ones, use IPivotDimensionLevelPropertiesCommon.IsChildrenBeforeParents.
Executing the example requires that the repository contains an express report with the EXPRESS identifier. Report data source is a cube that contains a dimension consisting of several levels.
Add links to the Express, Metabase, and Pivot system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Pivot: IPivot;
LHeader: IPivotHeader;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get express report
Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
// Get display settings of report data table
Pivot := Express.Pivot;
// Get collection of dimensions located by rows
LHeader := Pivot.LeftHeader;
// Check
If Not LHeader.IsChildrenBeforeParents Then
LHeader.ChildrenBeforeParents := TriState.OnOption;
End If;
// Save changes
(Express As IMetabaseObject).Save;
End Sub UserProc;
After executing the example child elements of hierarchy in the table sidehead are placed before parent ones.
See also: