IEaxAnalyzer.DrillCell

Syntax

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

Parameters

Row. Cell series index.

Column. Cell column index.

Description

The DrillCell method gets information on cell binding to data.

Comments

The Row and Column parameters transfer the cell coordinates. This method uses absolute cell size, thus it is required to take into consideration size of express report table header and table sidehead (IEaxGrid.HeaderSize).

Fore Example

Executing the example requires a form with the button named Button1 on it, the UiErAnalyzer component named UiErAnalyzer1 and other components, that display data of the express report, connected to the UiErAnalyzer1.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Expr: IEaxAnalyzer;
    DrillResult: IEaxDrillCellResult;
    DimSelection: IDimSelectionSet;
Begin
    Expr := UiErAnalyzer1.Instance As IEaxAnalyzer;
    DrillResult := Expr.DrillCell(1, 1);
    If DrillResult <> Null Then
        //Data source selection
        DimSelection := DrillResult.Selection;
        Debug.WriteLine(Dimensions in selection:  + DimSelection.Count.ToString);
    End If;
End Sub Button1OnClick;

The information about connection to B1 cell data is provided by clicking the button. If data of any source is displayed in the cell, the data source is also to be selected. The number of dimensions is shown in the development environment when selected.

Fore.NET Example

Executing the example requires a form with the button named Button1 on it, the UiErAnalyzerNet component named UiErAnalyzerNet1 and other components, that display data of the express report, connected to the UiErAnalyzerNet1.

Imports Prognoz.Platform.Forms.Net;
Imports Prognoz.Platform.Interop.Dimensions;
Imports Prognoz.Platform.Interop.Express;

Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    Expr: IEaxAnalyzer;
    DrillResult: IEaxDrillCellResult;
    DimSelection: IDimSelectionSet;
Begin
    Expr := UiErAnalyzerNet1.AnalyzerUi.Instance As IEaxAnalyzer;
    DrillResult := Expr.DrillCell(1, 1);
    If DrillResult <> Null Then
        //Data source selection
        DimSelection := DrillResult.Selection;
        System.Diagnostics.Debug.WriteLine(Dimensions in selection: " + DimSelection.Count.ToString());
    End If;
End Sub;