IExAnalyzerExporter.BulkSettings

Syntax

Description

The BulkSettings property returns parameters of a batch export of an express report.

Comments

The batch export is performed to the different files by default. Use the StartBatchCommand and FinishBatchCommand methods to export to the same file.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier. A report contains several sheets with at least one common fixed dimension of the sources.

Sub UserProc;
Var
    MB: IMetabase;
    Exp: IEaxAnalyzer;
    Exporter: IExAnalyzerExporter;
    BulkSetting: IEaxBulkSettings;
    SelSet: IDimSelectionSet;
Begin
    MB := MetabaseClass.Active;
    Exp := MB.ItemById("EXPRESS_REPORT").Bind As IEaxAnalyzer;
    Exporter := New ExAnalyzerExporter.Create;
    Exporter.ExAnalyzer := Exp;
    //Fixed dimensions selection
    SelSet := Exp.BulkSelectionSet;
    SelSet.Item(0).SelectAll;
    //Batch export execution option
    BulkSetting := Exporter.BulkSettings;
    BulkSetting.Enabled := True;
    BulkSetting.SelectionSet := SelSet;
    //Export
    Exporter.StartBatchCommand("c:\" + Exp.Name + ".XLS", "XLS");
    Exporter.ExportToFile("", "XLS");
    Exporter.FinishBatchCommand;
End Sub UserProc;

After executing the example the batch export of express report sheets is performed. The report variants are formed by all elements of the first fixed dimension. Exported to one file.