IPivotDimension.ReverseOrder

Syntax

ReverseOrder: Boolean;

Description

The ReverseOrder property determines whether a reverse order of elements in a dimension is used.

Comments

Reverse order of elements is observed only when a table is being constructed. In the elements itself, the order of elements is preserved according to parameters of a dictionary that is used as a dimension in a data source.

Example

Executing the example requires a form with the button named Button1, the TabSheetBox component and the UiErAnalyzer component named UiErAnalyzer1 which is data source for TabSheetBox.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    OLAP: IEaxAnalyzer;
    Dims: IPivotDimensions;
    Dim: IPivotDimension;
Begin
    OLAP := UiErAnalyzer1.ErAnalyzer;
    Dims := OLAP.Pivot.Dimensions;
    For Each Dim In Dims Do
        Dim.ReverseOrder := True;
    End For;
End Sub Button1OnClick;

After executing this example, clicking the button sets a reverse order of elements in all elements in the table. In the dimensions itself, order of elements is left without changes.