ColumnNumber - cDRReport ¶

Method Type¶

Function

Return Type¶

Arguments¶

Argument	Description
`sReportID`	ID of the report. Can be ID of the main report or the ID of a sub-report. This argument can be passed as an empty string. The empty string can be written as C_USEMAINDRREPORTID.
`iTableNumber`	Number of the table
`sColumnName`	Name of column, case insensitive

Description¶

Returns the number of the column in the report that matches the passed iTableNumber and sColumnName. The column names are compared in a case insensitive way. If the report contains no column with a matching name, the function will return -1.

This method cannot be used before the report OCX object is initialized. The COM object creation is - when not done before - created as part of the OpenReport method.

DataFlex Framework usage¶

Web
Windows
FlexTron

Sample¶

Object oReport is a cDRReport
    Set psReportName to 'MyReport.dr'
End_Object

Object oRunReportButton is a Button
    Set Label to 'Show column number'

    Procedure OnClick
        Integer iTable iColumn
        String sReportId

        Get OpenReport of oReport to sReportId
        If (sReportID <> '') Begin
            Get TableNumber of oReport sReportId "Customer" to iTable
            Get ColumnNumber of oReport sReportId iTable "Address" to iColumn
            Send Info_Box (SFormat ("Customer.Address = %1.%2", iTable, iColumn))
            Send CloseReport Of oReport sReportId
        End
    End_Procedure
End_Object

ColumnNumber - cDRReport¶