Detailing: TriState;
The Detailing property determines whether data drill down property.
To get attribute whether data drill down is used, use the IEaxGridDimensionSettings.IsDetailing property.
To execute the example, place the Button and Label components with the Button1 and Label1 identifiers respectively on the form.
Add links to the Express, Metabase, Pivot and Forms system assemblies.
The 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.
See also: