IPrxReportExporter.BulkSettings

Syntax

Description

The BulkSettings property returns settings of regular report batch export.

Comments

By default, the batch export is used to export data to different files. To export the data to the same file, use the StartBatchCommand and FinishBatchCommand methods.

Example

Executing the example requires that the repository contains a regular report with the Report_1 identifier. A common control linked to the dimension is created for the two first report sheets. The dimension is located in the fixed area of the slice.

Sub UserProc;
Var
    MB: IMetabase;
    RegRep: IPrxReport;
    Exporter: IPrxReportExporter;
    BulkSetting: IPrxBulkSettings;
    SelSet: IPrxBulkSelectionSet;
Begin
    MB := MetabaseClass.Active;
    RegRep := MB.ItemById("Report_1").Bind As IPrxReport;
    Exporter := New PrxReportExporter.Create;
        Debug.WriteLine(Exporter.BulkSettings = Null);
    Exporter.Report := RegRep;
    //Selection of fixed dimensions
    SelSet := RegRep.GetBulkSelectionSet("1-2");
    SelSet.Item(0).Selection.SelectAll;
    //Batch export settings
    BulkSetting := Exporter.BulkSettings;
    BulkSetting.Enabled := True;
    BulkSetting.SelectionSet := SelSet;
    //Export
    Exporter.StartBatchCommand("c:\" + RegRep.Name + ".XLS", "XLS");
    Exporter.ExportToFile("", "XLS");
    Exporter.FinishBatchCommand;
End Sub UserProc;

After executing the example two sheets of the regular report are batch exported. Report versions are based on all the elements of the fixed dimension. The sheets are exported to the same file.