IExAnalyzerExporter.BulkSettings

Fore Syntax

BulkSettings: IEaxBulkSettings;

Fore.NET Syntax

BulkSettings: Prognoz.Platform.Interop.Express.IEaxBulkSettings;

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.

 Fore Example

Executing this example requires that the repository contains an express report with the EXPRESS_REPORT identifier. 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.

 Fore.NET Example

Executing this example requires that the repository contains an express report with the EXPRESS_REPORT identifier. Report contains several sheets with at least one common fixed dimension of the sources. Selected procedure is an entry point for the .NET assembly.

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Exp: EaxAnalyzer;
    Exporter: IExAnalyzerExporter;
    BulkSetting: IEaxBulkSettings;
    SelSet: IDimSelectionSet;
Begin
    MB := Params.Metabase;
    Exp := MB.ItemById["EXPRESS_REPORT"].Bind() As EaxAnalyzer;
    Exporter := New ExAnalyzerExporterClass();
    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;

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.

See also:

IExAnalyzerExporter