pbXLSExportDataOnly - cDRReport¶
Methods - Properties - Events
Type¶
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.
Related topics¶
- pbXLSAllPages
- piXLSColumnWidth
- pbXLSExportGroupSections
- pbXLSExportNativeDatatype
- pbXLSExportPageSections
- pbXLSExportReportSections
- peXLSNewSheet
- piXLSPage
- peXLSVersion
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