ReportQuery - 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`.

Description¶

Returns the ODBC SQL query instruction sent by the report to the ODBC connection.

Generates an error when the result of the function call DatabaseType is not C_drODBC, C_drSP, or C_drSQL.

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 'Run Report'

    Procedure OnClick
        String sQuery sReportId

        Get OpenReport of oReport to sReportId
        If (sReportId <> '') Begin
            Send OutputReport of oReport
            Get ReportQuery of oReport sReportId to sQuery
            Send Info_Box sQuery "Report Query"
        End
    End_Procedure
End_Object

ReportQuery - cDRReport¶