ReportUsesStoredProcedures - 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 true when the data source of the report of any of the (nested) sub-reports is Stored Procedure based. Internally, it tests if the result of the function call DatabaseType is C_drSQL with sub-type C_drSP.

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 sReportId
        Boolean bUsesSP
        Integer iCustomerId iParameter

        Get OpenReport of oReport to sReportId
        If (sReportId <> '') Begin
            Get ReportUsesStoredProcedures of oReport sReportId to bUsesSP
            If (bUsesSP) Begin
               Get Value Of oCustomerNumberForm to iCustomerId
               Get ParameterIdByName sReportId "CustomerId" to iParameter
               If (iParameter <> -1) Begin
                  Set psParameterValue sReportId iParameter to iCustomerId
               End
            End
            Send OutputReport of oReport
            Send CloseReport of oReport sReportId
        End        
    End_Procedure
End_Object

ReportUsesStoredProcedures - cDRReport¶