IEaxGridDimensionSettings.Detailing

Fore Syntax

Detailing: TriState;

Fore.NET Syntax

Detailing: TriState;

Description

The Detailing property determines whether data drill down is used.

Comments

To get attribute whether data drill down is used, use the IEaxGridDimensionSettings.IsDetailing property.

Fore Example

To execute the example place the Button and Label components with the Button1 and Label1 identifiers correspondingly on the form.

Add links to the Express, Metabase, Pivot, Forms, ForeSystem (for Fore.NET) system assemblies.

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

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Eax: IEaxAnalyzer;
    Prop: IEaxGridDimensionSettings;
    PivotDim: IDataAreaHeaderSettingsBase;
Begin
    // Open express report with the key 71208
    Eax := MetabaseClass.Active.Item(71208).Edit As IEaxAnalyzer;
    // Find data source dimension with the key 10127
    PivotDim := Eax.Pivot.Dimensions.FindByKey(10127) As IDataAreaHeaderSettingsBase;
    // Check the data drilldown attribute
    Prop := Eax.Grid.ViewSettings.GetViewSettings(PivotDim) As IEaxGridDimensionSettings;
    If Prop.IsDetailing = False Then
        // Enable data drilldown, if it is disabled
        Prop.Detailing := TriState.OnOption;
        Label1.Text := "Data drilldown is enabled";
    Else
        // Disable data drilldown, if it enabled
        Prop.Detailing := TriState.OffOption;
        Label1.Text := "Data drilldown id disabled";
    End If;
    (Eax As IMetabaseObject).Save;
End Sub Button1OnClick;

Clicking the Button1 button in the Label1 component displays data drilldown state.

Fore.NET Example

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

Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Pivot;
Imports Prognoz.Platform.Interop.ForeSystem;

Private Sub button1_Click(sender: System.Object; e: System.EventArgs;);
Var
    MB: IMetabase;
    Eax: IEaxAnalyzer;
    Prop: IEaxGridDimensionSettings;
    PivotDim: IDataAreaHeaderSettingsBase;
Begin
    // Open express report with the key 71208
    MB := Self.Metabase;
    Eax := MB.Item[71208].Edit() As IEaxAnalyzer;
    // Find data source dimension with the key 10127
    PivotDim := Eax.Pivot.Dimensions.FindByKey(10127) As IDataAreaHeaderSettingsBase;
    // Check the data drilldown attribute
    Prop := Eax.Grid.ViewSettings.GetViewSettings[PivotDim] As IEaxGridDimensionSettings;
    If Prop.IsDetailing = False Then
        // Enable data drilldown, if it is disabled
        Prop.Detailing := TriState.tsOnOption;
        Label1.Text := "Data drilldown is enabled";
    Else
        // Disable data drilldown, if it enabled
        Prop.Detailing := TriState.tsOffOption;
        Label1.Text := "Data drilldown id disabled";
    End If;
    (Eax As IMetabaseObject).Save();
End Sub;