IEaxGrid.DrillCellResult

Fore Syntax

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

Fore.NET Syntax

DrillCellResult(Row: integer; Column: integer): Prognoz.Platform.Interop.Express.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.

Fore Example

Executing this example requires that the repository contains an express report with the EXPRESS_REPORT identifier. The report contains 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.

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;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Analyzer: IEaxAnalyzer;
    Grid: IEaxGrid;
Begin
    // Get repository
    MB := Params.Metabase;
    // 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.edtDown] Then
        Grid.DrillCellResult(1, 0);
    End If;
    // Save changes
    (Analyzer As IMetabaseObject).Save();
End Sub;