VB/Crystal Reports 9/CSV Export
Posted on 2003-03-06
Using the Crystal automation objects (CRAXDRT), I'm trying to export a detail-only [headers and footers suppressed] report created in Crystal 9. The desired file format is character-separated value with a comma as the field delimiter and nothing as the string delimiter. When I attempt this using the following code, a comma is used for both the field and string delimiter, resulting in 3 commas between each field (,Field1,,,Field2,,,Field3,)
Set oExport = MyReport.ExportOptions
oExport.FormatType = crEFTCommaSeparatedValues
oExport.CharFieldDelimiter = ","
oExport.CharStringDelimiter = ""
oExport.DestinationType = crEDTDiskFile
oExport.DiskFilename = "C:\MyFile.txt"
The report exports fine from the IDE.