IPivot.ABCRow

Syntax

ABCRow: Integer;

Description

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

Comments

Row 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 row index, 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 the 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. The analysis is executed by data of the third table row.

See also:

IPivot