IPivotFilter.SeparateHeaders

Syntax

SeparateHeaders: Boolean;

Description

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

Comments

Available values:

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.

See also:

IPivotFilter