ConditionType: PivotFilterType;
The ConditionType property determines the condition type, according to which data is filtered.
To use the property, it is required that:
The IPivotFilterSettings.Enabled property is set to True.
The IPivotFilterSettings.UseCondition property is set to True.
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: