IPivotFilter.SeparateHeaders

Fore Syntax

SuppressEmpty: Boolean;

Fore.NET Syntax

SupressEmpty: boolean;

Description

The SeparateHeaders property determines whether filtering settings are used separately for rows and columns.

Comments

Available values:

True. Filtering settings are used separately for rows and columns.
False. Default. Filtering settings are used for the entire table.

Fore Example

Executing the example requires that the repository contains an express report with the EXPRESS_FILTER identifier. The report contains a table.

Add links to the Express, Metabase and Pivot system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    LeftHeader: IPivotHeader;
    LeftFilter: IPivotHeaderFilterSettings;
    TopHeader: IPivotHeader;
    TopFilter: IPivotHeaderFilterSettings;
    Filter: IPivotFilter;
Begin
    MB := MetabaseClass.Active;
    Express := MB.ItemById("EXPRESS_FILTER").Edit As IEaxAnalyzer;
    Pivot := Express.Pivot;
    //Filtering parameters in table
    Filter := Pivot.Filter;
    Filter.SeparateHeaders := True;
    // Dimensions located by rows
    LeftHeader := Pivot.LeftHeader;
    LeftFilter := LeftHeader.Settings.Filter;
    LeftFilter.Enabled := True;
    LeftFilter.SuppressZeros := True;
    // Dimensions located by columns
    TopHeader := Pivot.TopHeader;
    TopFilter := TopHeader.Settings.Filter;
    LeftFilter.Enabled := True;
    TopFilter.SuppressEmpty := True;
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the rows, containing cells with zero values and columns containing cells with empty values, are filtered.

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;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    LeftHeader: IPivotHeader;
    LeftFilter: IPivotHeaderFilterSettings;
    TopHeader: IPivotHeader;
    TopFilter: IPivotHeaderFilterSettings;
    Filter: IPivotFilter;
Begin
    MB := Params.Metabase;
    Express := MB.ItemById["EXPRESS_FILTER"].Edit() As IEaxAnalyzer;
    Pivot := Express.Pivot;
    //Filtering parameters in table
    Filter := Pivot.Filter;
    Filter.SeparateHeaders := True;
    // Dimensions located by rows
    LeftHeader := Pivot.LeftHeader;
    LeftFilter := LeftHeader.Settings.Filter;
    LeftFilter.Enabled := True;
    LeftFilter.SuppressZeros := True;
    // Dimensions located by columns
    TopHeader := Pivot.TopHeader;
    TopFilter := TopHeader.Settings.Filter;
    LeftFilter.Enabled := True;
    TopFilter.SuppressEmpty := True;
    // Save changes
    (Express As IMetabaseObject).Save();
End Sub;