IEaxGrid.DrillRangeResult

Syntax

DrillRangeResult(Range: ITabRange): IEaxDrillRangeResult;

Parameters

Range. The cell range that requires a drilldown.

Description

The DrillRangeResult method returns result of data drilldown for the selected range of table cells.

Comments

If there was no drilldown, the method returns Null.

The range of cells, located in the table header or sidebar, should be transferred as the Range parameter. The specified range should correspond to one dimension. When executing this method, selection by dimension, to which the range corresponds, will be changed. The data aggregation is enabled when the dimension is fixed by the Range range elements.

Use the IEaxGrid.IsRangeDrillable property to check if data can be drilled down.

To get drilldown result for the specified table cell, use IEaxGrid.DrillCellResult.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier. The report contains a table.

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

Sub UserProc;
Var
    MB: IMetabase;
    Analyzer: IEaxAnalyzer;
    Grid: IEaxGrid;
    Range: ITabRange;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Analyzer := MB.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
    // Get report data table
    Grid := Analyzer.Grid;
    // Get cell range
    Range := Grid.TabSheet.Cells(0, 0, 1, 2);
    // Drill down, if it is possible
    If Grid.IsRangeDrillable(Range, EaxDrillType.Down) Then
        Grid.DrillRangeResult(Range);
    End If;
    // Save changes
    (Analyzer As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, checking whether data drilldown in the A0:C1 cell range is available is performed. The drilldown is performed if available.