IPivotHighlightItem.Range

Syntax

Range: IPivotFilterRange;

Description

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.

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 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:

IPivotHighlightItem