Skip to content

pbXLSExportDataOnly - cDRReport

Methods - Properties - Events

Type

Boolean

Default

False

Arguments

None

Description

Exporting the report to XLS can be done in two ways: - Data Only - With page formatting

Setting pbXLSExportDataOnly to true does not export close to the preview but focusses on the data.

Can be retrieved or set after the OCX is initialized.

DataFlex Framework Usage

  • Web
  • Windows
  • FlexTron

Sample

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

Object oExportToXLSReportButton is a Button
    Set Label to 'Export Report to XLS'

    Procedure OnClick
        String sReportId

        Get OpenReport of oReport to sReportId
        If (sReportId <> '') Begin
            Set pbXLSExportDataOnly of oReport to True
            Send ExportReport of oReport C_drXLS 'c:\tmp\MyReport.xls'
        End
    End_Procedure
End_Object