IPrxTableIslandGrouping.Separated

Syntax

Separated : TriState;

Description

The Separated property determines status of the Arrange in Separate Column option for a group. When the option is enabled, grouped data is arranged in a separate column.

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.IsSeparated Then

Gr.Separated := TriState.OffOption;

End If;

TI.Save;

MObj.Save;

End Sub Main;

After executing the example the Arrange in Separate Column option is disabled if 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.