IPivotFilterSettings.ConditionType

Syntax

ConditionType: PivotFilterType;

Description

The ConditionType property determines the condition type, according to which data is filtered.

Comments

To use the property, it is required that:

  1. The IPivotFilterSettings.Enabled property is set to True.

  2. The IPivotFilterSettings.UseCondition property is set to True.

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;
    Filter: IPivotFilter;
    FilterSet: IPivotFilterSettings;
Begin
    // Get access to repository
    MB := MetabaseClass.Active;
    // Get access to express report
    Express := MB.ItemById("EXPRESS_FILTER").Edit As IEaxAnalyzer;
    Pivot := Express.Pivot;
    // Determine filtering parameters in table
    Filter := Pivot.Filter;
    FilterSet := Filter As IPivotFilterSettings;
    // Enable filtering parameters for table
    FilterSet.Enabled := True;
    // Use filtering condition
    FilterSet.UseCondition := True;
    // Set the filtering type "Between A and B inclusively"
    FilterSet.ConditionType := PivotFilterType.NLAandNGB;
    //  Set value of A
    FilterSet.ConditionValueA := 100;
    // Set value of B
    FilterSet.ConditionValueB := 200;
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example data is filtered in express report table. Data located in the cells, which values are in the interval [100; 200], is filtered.

See also:

IPivotFilterSettings