IPivot.ABCRow

Syntax

ABCRow: Integer;

Description

The ABCRow property determines index of the row, by which the 80/20 analysis is performed.

Comments

Lines indexing starts with zero. To cancel using of the 80/20 analysis by rows, set this property to "-1". The property is available only via Fore.

NOTE. The property is outdated. The property is outdated. To get 80/20 analysis parameters use the Pareto property, to specify index of the row use the ElementIndex property.

Example

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

Sub UserProc;

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;

//A row, by which the analysis is performed

Expr.Pivot.ABCRow := 2;

MObj.Save;

End Sub UserProc;

After executing this example, formatting styles of a header and cells of a row, to which the 80/20 analysis is applied, are changed for an express report. Analysis is performed by data of the third table row.

See also:

IPivot