IEaxDataAreaSlice.AdditionalFilterTransformations

Fore Syntax

AdditionalFilterTransformations: IEaxDataAreaTransformations;

Fore.NET Syntax

AdditionalFilterTransformations: Prognoz.Platform.Interop.Express.IEaxDataAreaTransformations;

Description

The AdditionalFilterTransformations property returns object to work with collection of columns transformation in case of separate filtering of table rows and columns is enabled.

Comments

Separated filtering for rows and columns is determined by the IPivotFilter.SeparateHeaders property. On executing separated filtering, transformations for columns are in this collection. Is separated filtering is not used, the collection will be empty.

Fore Example

Executing the example requires that repository has regular report with the EXPRESS_FILTER identifier. The report contains table. The report must contain separated filtering for rows and columns. For rows filtering settings several formulas must be set. The setting is made using the FilterSetup  command of the Express plagin.

Add link to the Express, Metabase, Pivot system assemblies.

Sub main;
Begin
    UserProc;
End Sub main;

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Dim: IEaxDataAreaSlice;
    Top: IEaxDataAreaTransformations;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS_FILTER").Bind As IEaxAnalyzer;
    // Get table displaying settings
    Dim := Express.DataArea.Slices.Item(0);
    Top := Dim.AdditionalFilterTransformations;
    Debug.WriteLine("Number of transformations set for columns = " + Top.Count.ToString);
End Sub UserProc;

After executing the example the console displays number of columns transformation on activated separated filtering for table rows and columns.

Fore.NET Example

The requirements and result of the Fore.NET Example execution match with those in the Fore Example.

Imports Prognoz.Platform.Interop.Express;

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Dim: IEaxDataAreaSlice;
    Top: IEaxDataAreaTransformations;
Begin
    // Get repository
    MB := Params.Metabase;
    // Get express report
    Express := MB.ItemById["EXPRESS_FILTER"].Bind() As IEaxAnalyzer;
    // Get table displaying settings
    Dim := Express.DataArea.Slices.Item[0];
    Top := Dim.AdditionalFilterTransformations;
    System.Diagnostics.Debug.WriteLine
    ("Number of transformations set for columns = " + Top.Count.ToString());
End Sub;

See also:

IEaxDataAreaSlice