IPivotFilter.SeparateHeaders

Syntax

SeparateHeaders: 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 value. Filtering settings are used for the entire table.

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.