Area: PivotFilterArea;
The Area property determines the area, to which data filtering is applied.
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;
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 the example clicking the button filters the data in the specified range of an express report table loaded into the UiErAnalyzer1 component. Data in rows, in which values exceed 100, is filtered.
See also: