IEaxTableStyle.ABCStyle

Syntax

Description

The ABCStyle property determines formatting style applied to cells of the column with enabled 80/20 analysis in the express report table.

Example

Executing this example requires that the repository contains an express report with the EXPRESS_REPORT identifier.

Sub Main;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Expr: IEaxAnalyzer;

Grid: IEaxGrid;

Style: IEaxTableStyle;

HeaderStyle, CellStyle: ITabCellStyle;

Begin

MB := MetabaseClass.Active;

MObj := MB.ItemById("EXPRESS_REPORT").Edit;

Expr := MObj As IEaxAnalyzer;

Grid := Expr.Grid;

//header style

HeaderStyle := New TabCellStyle.Create;

HeaderStyle.BackgroundColor := GxColor.FromName("Green");

HeaderStyle.Font.Bold := TriState.OnOption;

//cell style

CellStyle := New TabCellStyle.Create;

CellStyle.BackgroundColor := GxColor.FromName("Yellow");

Style := Grid.Style;

Style.ABCHeaderStyle := HeaderStyle;

Style.ABCStyle := CellStyle;

//The column for which the 80/20 analysis is enabled

Expr.Pivot.ABCColumn := 2;

MObj.Save;

End Sub Main;

After executing this example, formatting styles are changed for header and cells of the column for which the 80/20 analysis is enabled. Analysis is applied to data of the third table column.