IEaxGridHeaderSettings.Behaviour

Syntax

Description

The Behaviour property determines rows and columns behavior on data area insertion.

Comments

The property is relevant only for the regular report data area.

Example

Executing the example requires a regular report with the REPORT identifier. The report contains the data area with the dropdown hierarchy.

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

Sub UserProc;
Var
    mb: IMetabase;
    Report: IPrxReport;
    Table: ITabSheet;
    DataArea: IEaxDataAreaViews;
    Grid: IEaxGrid;
    Slice: IEaxDataAreaPivotSlice;
    SettBase: IDataAreaHeaderSettingsBase;
    ViewSett: IEaxGridViewSettings;
    sett: IEaxGridHeaderSettings;
Begin
    mb := MetabaseClass.Active;
    Report :=  MB.ItemById("REPORT").Edit As IPrxReport;
    Table := (Report.ActiveSheet As IPrxTable).TabSheet;
    DataArea := Report.DataArea.Views;
    Grid := DataArea.FindById("EaxObject") As IEaxGrid;
    Slice := Grid.Slice As IEaxDataAreaPivotSlice;
    SettBase := Slice.Pivot.LeftHeader As IDataAreaHeaderSettingsBase;
    ViewSett := Grid.ViewSettings;
    sett := ViewSett.GetViewSettings(SettBase) As IEaxGridHeaderSettings;
    // Behavior of rows and columns
    sett.Behaviour := EaxGridHeaderBehaviour.Fixed;
    // Sorting icons visibility
    sett.DisplaySortIcons := True;
    // Indent in drop-down hierarchy
    sett.HierarchyIndent := 15;
    (Report As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the following settings will be specified for the sidehead of the regular report data area:

Fixed size of rows and columns is used.
Sorting icons are visible.
Indent in the dropdown hierarchy is specified.