Range: IPivotFilterRange;
The Range property returns the range, in which the data is highlighted. It is relevant if the Area property is set to the PivotFilterArea.Range value.
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;
Table: IPivotTable;
HighItems: IPivotHighlightItems;
HighItem: IPivotHighlightItem;
Range: IPivotFilterRange;
Begin
OLAP := UiErAnalyzer1.ErAnalyzer;
Pivot := OLAP.Pivot;
Table := Pivot.ObtainTable;
HighItems := Pivot.Highlight;
HighItem := HighItems.Add;
HighItem.ConditionType := PivotHighlightType.ALargest;
HighItem.ConditionValueA := 1;
HighItem.Area := PivotFilterArea.Range;
Range := HighItem.Range;
Range.Left := 0;
Range.Right := Table.ColumnCount;
Range.Top := 0;
Range.Bottom := 0;
HighItem.Enabled := True;
OLAP.Grid.ApplyHighlight(HighItem);
End Sub Button1OnClick;
After executing the example clicking the button creates a new condition of data highlighting in the table of the express report loaded to the UiErAnalyzer1 component. The cell containing maximum value is highlighted in the first row.
See also: