IPivotFilter.Elements

Syntax

Elements: PivotFilterElements;

Description

The Elements property determines a table element, according to which the filtering is performed.

Example

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 the TabSheetBox component.

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 this 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 out. Columns, containing zero or empty values, are also filtered out.

See also:

IPivotFilter