|
-
June 27th, 2011, 05:00 AM
#1
How to export crystal report in excel with data only
Hi,
I am now using this code to export report to excel format
Code:
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 ?
-
June 27th, 2011, 10:49 AM
#2
Re: How to export crystal report in excel with data only
If you're saving an XLS file, it won't be text.
-
June 27th, 2011, 11:40 AM
#3
Re: How to export crystal report in excel with data only
If you want to export data only I would consider using a query and save the data from the resulting recordset to a csv file.
Can't help with Crystal as I scrapped that software years ago in favor of a more VB friendly report tool.
Always use [code][/code] tags when posting code.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!