IPivotHeaderNumbering.IsOn

Syntax

IsOn: Boolean;

Description

The IsOn property determines whether continuous numbering is used in table headers.

Comments

Available values:

True. Continuous numbering is used in header rows or columns. If the numbering is enabled in headers, an extra row or column is added, in which numbers of data columns or rows are specified. The same formatting is applied to the extra row or column, which is determined for headers.
False. Continuous numbering is not used. Default value.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier. This report should contains a data table. Two dimensions should be present in the report sidehead and heading.

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;
    //Enable displaying of numbering
    Numbering.IsOn := True;
    //Take into account header rows in numbering
    Numbering.ConsiderHeader := True;
    //Display numbering at the end of header
    Numbering.PlaceAtEnd :=True;
    //Set numbering taking into account element indents
    Numbering.AutoIdent:= True;
    //Set dimension numbering that does not depend on each other
    Numbering.CrossDimension:= False;
    //Determine initial values of numbering
    Numbering.StartIndex:= 3;
    //Add numbering prefix
    Numbering.Prefix:= "№";
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, continuous numbering is enabled for rows starting from three and with the No. prefix. Numbering will take into account the number of header rows and dimension element indents. Numbering will be independent for different dimensions and will be at the end of each row's header.