IPivotHeaderNumbering.CornerFormat

Syntax

CornerFormat: PivotNumberingFormat;

Description

The CornerFormat property returns the numbering format in the corner.

Comments

Arabic numbers are used by default.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier. This report must include a data table.

Add links to the Metabase, Express, Pivot system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    Header: IPivotHeader;
    Numbering: IPivotHeaderNumbering;

Begin
    MB := MetabaseClass.Active;
    Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
    Pivot := Express.Pivot;
    Header := Pivot.LeftHeader;
    //Row numbering parameters
    Numbering := Header.Numbering;
    Select Case Numbering.CornerFormat As Integer
        Case 0: Debug.WriteLine("Numbering format in the corner - Arabic numbers");
        Case 1: Debug.WriteLine("Numbering format in the corner - Latin letters in lower case");
        Case 2: Debug.WriteLine("Numbering format in the corner - Latin letters in upper case");
        Case 3: Debug.WriteLine("Numbering format in the corner - Roman numbers in lower case");
        Case 4: Debug.WriteLine("Numbering format in the corner - Roman numbers in upper case");
        Case 5: Debug.WriteLine("Numbering format in the corner - Cyrillic letters in lower case");
        Case 6: Debug.WriteLine("Numbering format in the corner - Cyrillic letters in upper case");
    End Select; 
End Sub UserProc;

After executing the example clicking the button displays numbering format in the corner of this express report in the console.

See also:

IPivotHeaderNumbering