IPivotTableHeader.ElementNameEx

Syntax

ElementNameEx(SlotNumber: Integer; ElementNumber: Integer): Variant;

Parameters

SlotNumber. Slot index in the table header.

ElementNumber. Element index in the table header.

Description

The ElementNameEx property returns name of the dimension element, to which the given table header element corresponds, taking into account regional parameters settings.

Comments

The property is relevant if the work is executed with the header elements, which show some additional dimension attributes. Values by these attributes may depend on the regional settings (real values, data or time).

Example

Executing the example requires a form with the Button1 button, the UiErAnalyzer component named UiErAnalyzer1 and any visualizers, for which UiErAnalyzer1 is set as a data source. UiErAnalyzer1 is connected to express report. The express report contains a dimension located by rows, for which additional attributes are displayed as element names. Value of the attribute displayed in the second slot depends on the regional parameters settings. Add links to the Express, Pivot system assemblies.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    Header: IPivotTableHeader;
    i: Integer;
Begin
    Express := UiErAnalyzer1.Instance As IEaxAnalyzer;
    Pivot := Express.Pivot;
    Header := Pivot.ObtainTable.LeftHeader;
    Debug.WriteLine(Header.ElementName(1, 0));
    Debug.WriteLine(Header.ElementNameEx(1, 0));
End Sub Button1OnClick;

Clicking the button of the first element of the dimension, located by rows, the development environment console shows values of the attribute used as a name and displayed in the second slot of the table. Actual value and value converted according to the regional parameters settings are displayed.