IEaxGridHeaderSettings.Behaviour

Fore Syntax

Behaviour: EaxGridHeaderBehaviour;

Fore.NET Syntax

Behaviour: Prognoz.Platform.Interop.Express.EaxGridHeaderBehaviour;

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.

Fore 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.

Fore.NET Example

The requirements and result of the Fore.NET Example execution match with those in the Fore Example.

Imports Prognoz.Platform.Interop.Report;
Imports Prognoz.Platform.Interop.Tab;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.ForeSystem;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    mb: IMetabase;
    Report: IPrxReport;
    Table: ITabSheet;
    DataArea: IEaxDataAreaViews;
    Grid: IEaxGrid;
    Slice: IEaxDataAreaPivotSlice;
    SettBase: IDataAreaHeaderSettingsBase;
    ViewSett: IEaxGridViewSettings;
    sett: IEaxGridHeaderSettings;
Begin
    mb := Params.Metabase;
    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.eghbFixed;
    // Sorting icons visibility
    sett.DisplaySortIcons := True;
    // Indent in drop-down hierarchy
    sett.HierarchyIndent := 15;
    (Report As IMetabaseObject).Save();
End Sub;