IPivotFilter.Area

Syntax

Area: PivotFilterArea;

Description

The Area property determines an area, to which data filtering is applied.

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;

Range: IPivotFilterRange;

Begin

OLAP := UiErAnalyzer1.ErAnalyzer;

Pivot := OLAP.Pivot;

Filter := Pivot.Filter;

Filter.ConditionType := PivotFilterType.GA;

Filter.ConditionValueA := 100;

Filter.Elements := PivotFilterElements.Rows;

Range := Filter.Range;

Range.Left := 0;

Range.Right := 0;

Range.Top := 9;

Range.Bottom := 9;

Filter.Area := PivotFilterArea.Range;

Filter.UseCondition := True;

End Sub Button1OnClick;

After executing this example, clicking the button filters the data in the assigned range of an express report table, loaded into the "UiErAnalyzer1" component. Data in rows, in which values exceed 100, is filtered out.

See also:

IPivotFilter