How to export crystal report in excel with data only

[naruponk]

Hi,

I am now using this code to export report to excel format

    Report.ExportOptions.ExcelExportAllPages = True
    Report.ExportOptions.DestinationType = crEDTDiskFile
    Report.ExportOptions.FormatType = crEFTExcel97
    Report.ExportOptions.DiskFileName = "D:\CommBackup\" & rs.Fields!MemberCode & "-" & Right(Year(DT1.Value), 2) & Format(Month(DT1.Value), "00") & ".xls"
    Report.Export (False)

But how to export to excel with data only ?