IPivotSorter.Diapason

Syntax

Description

The Diapason property determines the range, in which data sorting is executed.

Example

Executing the example requires that the repository contains a regular report with the REPORT identifier. The source, based on which a slice and the Table visualizer are created, is added to the report.

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

Sub UserProc;
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Pivot: IPivot;
Begin
    Mb := MetabaseClass.Active;
    Report := Mb.ItemById("REPORT").Edit As IPrxReport;
    Pivot := (Report.DataArea.Slices.Item(0) As IEaxDataAreaPivotSlice).Pivot;
    // Set sorting range
    Pivot.Sorter.Diapason := PivotSortDiapason.HierarchyLevel;
    // Save changes
    Report.MetabaseObject.Save;
End Sub UserProc;

After executing the example the range is set, in which sorting is executed in the data slice: sorting will be executed with saving hierarchy by all dimension element levels.