Report > Report Assembly Interfaces > IPrxReportExporter > IPrxReportExporter.Sheet

IPrxReportExporter.Sheet

Syntax

Description

The Sheet property determines the regular report sheet to be exported.

Comments

If the property is set to NULL, the entire report is exported. The entire report is exported by default. Use the ExportRange property to set the range of sheets to be exported.

Example

The following example assumes that there is the Report object with the IPrxReport type.

Sub UserProc;
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Exp: IPrxReportExporter;
Begin
    Mb := MetabaseClass.Active;
    Rep := Mb.ItemById("OBJ_REPORT").Bind As IPrxReport;
    Exp := New PrxReportExporter.Create;
    Exp.Report := Report;
    Exp.Sheet := Report.Sheets.Item(0);
    Exp.ExportToFile("C:\Report.xls", "xls");
End Sub UserProc;

After executing the example only the first sheet of the regular report is exported to the specified format.