IPrxFormulaIsland.Sheet

Syntax

Sheet: IPrxSheet;

Description

The Sheet property determines the sheet of the regular report that contains the formula area.

Example

Sub Main;

Var

MB: IMetabase;

Report: IPrxReport;

FormulaIs: IPrxFormulaIslands;

Formula: IPrxFormulaIsland;

Sheet: IPrxSheet;

s: String;

Begin

MB := MetabaseClass.Active;

Report := MB.ItemById("Report").Bind As IPrxReport;

FormulaIs := Report.FormulaIslands;

Formula := FormulaIs.Item(0);

Sheet := Formula.Sheet;

s := Sheet.Name;

End Sub Main;

After executing the example the "s" variable contains the title of the regular report sheet containing the first formula area. The identifier of the regular report - Report.