IPrxDataElementStyleCommon.Condition

Syntax

Condition: IExpression;

Description

The Condition property determines the condition checked for each cell. If the condition is satisfied, the specified formatting is applied to the cell. The formatting style is determined by the Conditional property.

The property is outdated, use FormatConditions.

Example

The following example assumes that there is the Report object with the IPrxReport type.

Sub UserProc;

Var

Report: IPrxReport;

DIs: IPrxDataIslands;

DI: IPrxDataIsland;

DimModel: IDimensionModel;

Prop: IPrxDataIslandProperties;

PropDim: IPrxDataIslandDimension;

Level: IPrxDataIslandLevel;

Style: IPrxDataElementStyle;

Begin

DIs := Report.DataIslands;

DI := DIs.Item(0).Edit;

DimModel := DI.Slice.TopHeader.Item(0).Dimension.Dimension;

Prop := DI.Properties;

PropDim := Prop.Dimension(DimModel);

Level := PropDim.Level(DimModel.Levels.Item(0));

Style := Level.Style;

Style.Condition.AsString := "VALUE < 100";

DI.Save;

End Sub UserProc;

Executing the example changes the formula that determines whether formatting is applied to the first level of the specified dimension located in columns.