IEaxGrid.DrillCellResult

Syntax

DrillCellResult(Row: Integer; Column: Integer): IEaxDrillCellResult;

Parameters

Row. Row index where cell is placed.

Column. Column index where cell is placed.

Description

The DrillCellResult method returns result of data drilldown for the selected table cell.

Comments

If there was no drilldown, the method returns Null.

The coordinates of one of the cells, located in the header or row header of the table, are required to be transferred as Row and Column parameter values. On executing the method, selection by dimension to which corresponds the cell will be changed.

To check whether data can be drilled down, use the IEaxGrid.IsCellDrillable property.

To get result of data drilldown for specified table cells range, use IEaxGrid.DrillRangeResult.

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 system assemblies.

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

After executing the example, checking whether data drilldown by the B0 cell is available is performed. The drilldown is performed if available.