Elements: PivotFilterElements;
The Elements property determines the table element, by which filtering is executed.
Executing the example requires a form with the Button1 button, the TabSheetBox component and the UiErAnalyzer component named UiErAnalyzer1, which is used as a data source for TabSheetBox.
Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
OLAP: IEaxAnalyzer;
Pivot: IPivot;
Filter: IPivotFilter;
Begin
OLAP := UiErAnalyzer1.ErAnalyzer;
Pivot := OLAP.Pivot;
Filter := Pivot.Filter;
Filter.Area := PivotFilterArea.Table;
Filter.ConditionType := PivotFilterType.NLAandNGB;
Filter.ConditionValueA := 100;
Filter.ConditionValueB := 200;
Filter.Elements := PivotFilterElements.Columns;
Filter.SuppressZeros := True;
Filter.SuppressEmpty := True;
Filter.UseCondition := True;
End Sub Button1OnClick;
After executing the example clicking the button filters data in table of the express report loaded into the UiErAnalyzer1 component. Data in columns, values in which are in the range of [100,200], is filtered. Columns, containing zero or empty values, are also filtered.
See also: