IPivotFilterSettings.SupressEmpty

Syntax

SupressEmpty: Boolean;

Description

The SupressEmpty property determines whether cells with empty values are filtered.

Comments

Available values:

True. Cells with empty values are filtered.
False. Default value. Cells with empty values are not filtered.

To use the property, set the IPivotFilterSettings.Enabled property to True.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_FILTER identifier. The report contains a table. At least one element of the last table dimension must not satisfy the filtering condition.

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

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    LeftHeader: IPivotHeader;
    Filter: IPivotFilter;
    FilterSet: IPivotFilterSettings;
Begin
    MB := MetabaseClass.Active;
    Express := MB.ItemById("EXPRESS_FILTER").Edit As IEaxAnalyzer;
    Pivot := Express.Pivot;
    // Dimensions located by rows
    LeftHeader := Pivot.LeftHeader;
    // Filtering parameters in table
    Filter := Pivot.Filter;
    FilterSet := Filter As IPivotFilterSettings;
    // Enable filtering parameters for table
    FilterSet.Enabled := True;
    // Enable filtering of empty cell values
    FilterSet.SuppressEmpty := True;
    // Enable filtering of zero cell values
    FilterSet.SuppressZeros := True;
    // Enable filtering of non-numeric cell values
    FilterSet.SuppressNoNumeric := True;
    // Keep non-excluded element owners
    FilterSet.KeepParent := True;
   // Filter data by last dimension hierarchy levels
    FilterSet.KeepNeighbors := True;
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example empty, zero, and non-numeric cell values are filtered in the table. After filtering owners of non-excluded elements are also displayed. The last dimension level is displayed because one of its elements does not satisfy the filtering condition.