IPrxTableIslandGrouping.Hierarchical

Syntax

Hierarchical: TriState;

Description

The Hierarchical property determines status of the Pop-Up Hierarchy option for a group. When the option is enabled, the hierarchy of the grouped data can be expanded and collapsed using owner's icons.

The option is enabled by default.

Example

Sub Main;

Var

MB: IMetabase;

MObj : IMetabaseObject;

Report : IPrxReport;

TabIs : IPrxTableIslands;

TI : IPrxTableIsland;

Grs : IPrxTableIslandGroupings;

Gr : IPrxTableIslandGrouping;

Begin

MB := MetabaseClass.Active;

MObj := MB.ItemById("Report").Edit;

Report := MObj As IPrxReport;

TabIs := Report.TableIslands;

TI := TabIs.Item(0);

TI := Ti.Edit;

Grs := TI.Groupings;

Gr := Grs.Item(0);

If Gr.IsHierarchical Then

Gr.Hierarchical := TriState.OffOption;

End If;

TI.Save;

MObj.Save;

End Sub Main;

After executing the example the Pop-Up Hierarchy option is disabled in case it has been enabled earlier. Report - identifier of the regular report, which sheet contains a relational data area, for which the group has been created.