I have written a crystal report that I have included some groupings, but kept them as surpressed (no drill down). When I export this report from Crystal designer, everything work fine, but when I use the following code to export it, for each line Crystal exports the column headers and then the data.
ex:
If I have the following coltents in Table 1
id empid name
111 a1 aaa
222 b2 bbb
333 c3 ccc
I have grouped my report on id and kept it surpresed. I use the following code to export the report
Dim myReport As New ReportDocument myReport.Load("c:\test\test1.rpt") Dim CrExportOptions As ExportOptions Dim CrDiskFileDestinationOptions As New DiskFileDestinationOptions() Dim CrFormatTypeOptions As New CharacterSeparatedValuesFormatOptions CrFormatTypeOptions.SeparatorText = "" CrFormatTypeOptions.Delimiter = "" CrFormatTypeOptions.ExportMode = CsvExportMode.Standard CrFormatTypeOptions.ReportSectionsOption = CsvExportSectionsOption.Export CrFormatTypeOptions.GroupSectionsOption = CsvExportSectionsOption.Export CrDiskFileDestinationOptions.DiskFileName = tmpfile CrExportOptions = myReport.ExportOptions With CrExportOptions .ExportDestinationType = ExportDestinationType.DiskFile '.ExportFormatType = ExportFormatType.Excel '.ExportFormatType = ExportFormatType.CharacterSeparatedValues .ExportFormatType = ExportFormatType.CharacterSeparatedValues .DestinationOptions = CrDiskFileDestinationOptions .FormatOptions = CrFormatTypeOptions End With myReport.Export()
With this code I get hte following file
id empid name 111 a1 aaa
id empid name 222 b2 bbb
id empid name 333 c3 ccc
How do I skip the column headers? Any help is greatly appreciated.