IPivot.MergedAdditionalNamingMode

Syntax

MergedAdditionalNamingMode: PivotMergedNamingMode;

Description

The MergedAddtionalNamingMode property determines a method for merging additional names of elements of different dimensions.

Comments

To determine a method for merging names of elements of different dimensions, use the IPivot.MergedNamingMode property.

Example

To execute the example, place on the form the Button component named Button1, the TabSheetBox component named TabSheetBox1, and the UiErAnalyzer component named UiErAnalyzer1. Specify UiErAnalyzer1 as a data source for TabSheetBox1. An express report is a data source for UiErAnalyzer1.

Add links to the Dimension, Express, ExtCtrls, Forms, Pivot, and Tab system assemblies.

The example is a handler of the OnClick event for the Button1 component.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Eax: IEaxAnalyzer;
    Pivot: IPivot;
    Key: Integer;
    DimSettings: IPivotDimensionSettingsEx;
Begin
    Eax := UiErAnalyzer1.ErAnalyzer;
    Pivot := Eax.Pivot;
    // Set merge method and separator that will be used in additional name
    Pivot.MergedAdditionalNamingMode := PivotMergedNamingMode.UpperElement Or PivotMergedNamingMode.LowerElement;
    Pivot.MergedAdditionalNamingSeparator := " | ";
    // Get key of the second dimension located in sidehead
    Key := Pivot.LeftHeader.Dim(1).Key;
    // Set up dimensions
    DimSettings := Pivot.Dimensions.FindByKey(Key).Settings;
    // Determine the element, which name will be merged with elements of the dimension at higher level
    DimSettings.MergedElement := 0;
    // Display information about advanced settings of table change in the console
    Debug.Write("Tucking of merged dimension elements with elements of previous dimension ");
    If DimSettings.MergeTopDown = True Then
        Debug.WriteLine("is being executed");
        Else
            Debug.WriteLine("is not eing executed");
    End If;
    Debug.Write("Number of selection elements after merge: ");
    Debug.WriteLine(DimSettings.MergedSelection.SelectedCount);
End Sub Button1OnClick;

Clicking the button enables in express report sidehead merging of names of higher level elements with element of the second dimension, the console displays information about advanced settings of table dimensions.