IPivotHighlightItem.ConditionValueB

Syntax

ConditionValueB: Variant;

Description

The ConditionValueB property determines the second value that is used on determining highlighted data.

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;

Begin

OLAP := UiErAnalyzer1.ErAnalyzer;

Pivot := OLAP.Pivot;

Table := Pivot.ObtainTable;

HighItems := Pivot.Highlight;

HighItem := HighItems.Add;

HighItem.ConditionType := PivotHighlightType.NLAandNGB;

HighItem.ConditionValueA := 100;

HighItem.ConditionValueB := 200;

HighItem.Enabled := True;

HighItem.Area := PivotFilterArea.Table;

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. Cells with values in the range [100,200] are highlighted in the entire table.