IPivotFilterSettings.SupressEmpty

Fore Syntax

SupressEmpty: Boolean;

Fore.NET 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. Cells with empty values are not filtered.

To use the property, it is required that the IPivotFilterSettings.Enabled property is set to True.

Fore 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.

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;
    Filter: IPivotFilter;
    FilterSet: IPivotFilterSettings;
Begin
    MB := Params.Metabase;
    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 cells
    FilterSet.SuppressEmpty := True;
    // Enable filtering of zero cells
    FilterSet.SuppressZeros := True;
    // Enable filtering of non-numeric cells
    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;