Sheet: IPrxSheet;
Sheet: Prognoz.Platform.Interop.Report.IPrxSheet;
The Sheet property determines the sheet of the regular report that contains the data area.
Executing the example requires a form with the Button1 button, a regular report with the REPORT identifier, which contains a data area. Add links to the Metabase, Report, Ui system assemblies. The example is an event handler for the Button1 button.
Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
MB: IMetabase;
MObj: IMetabaseObject;
DI: IPrxDataIsland;
Begin
MB := MetabaseClass.Active;
MObj := MB.ItemById("REPORT").Bind;
DI := (MObj As IPrxReport).DataIslands.Item(0);
// Display a message with the sheet name.
WinApplication.InformationBox(DI.Sheet.Index.ToString, self As IWin32Window);
End Sub Button1OnClick;
After executing the example clicking the button displays a message with the sheet name (numeration starts with zero), which contains the first data area of the REPORT regular report.
The requirements and result of the Fore.NET example execution match with those in the Fore example.
Imports Prognoz.Platform.Interop.Ui;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Report;
...
Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
MB: IMetabase;
MObj: IMetabaseObject;
DI: IPrxDataIsland;
WA : WinApplicationClass = New WinApplicationClassClass();
Begin
MB := Self.Metabase;
MObj := MB.ItemById["REPORT"].Bind();
DI := (MObj As IPrxReport).DataIslands.Item[0];
// Display a message with the sheet name.
WA.InformationBox(DI.Sheet.Index.ToString, New IWin32WindowForeAdapter(Self));
End Sub;
See also: