1586586 - Exporting to character-separated value (CSV) format, Page Header appears at the beginning of each record

• Using the InProc RAS SDK for VS .NET
• Exporting to character-separated value (CSV) format, Page Header appears at the beginning of each record
• Page Header should only appear once at the beginning of the CSV file

• CRVS2010, Service Pack 1
• Crystal reports 2008, Service Pack 3

• The following code will ensure that the Page Header is only exported at the beginning of the CSV file:

Sub exportToCsv_Ras(ByVal fileName$, ByVal charStringDelimiter$, ByVal charFieldDelimiter$)

 Dim exportOptions As New CrystalDecisions.ReportAppServer.ReportDefModel.ExportOptions
 Dim CSVexportOptions As New CharacterSeparatedValuesExportFormatOptions

 exportOptions.ExportFormatType = CrReportExportFormatEnum.crReportExportFormatCharacterSeparatedValues
 CSVexportOptions.Delimiter = charStringDelimiter$
 CSVexportOptions.ExportMode = CrCSVExportModeEnum.crCSVExportModeStandard
 CSVexportOptions.ReportSectionsOption = CrCSVExportSectionsOptionEnum.crCSVExportSectionsOptionExport
 CSVexportOptions.Separator = charFieldDelimiter$

 'Following is the critical line of code
 CSVexportOptions.GroupSectionsOption = CrCSVExportSectionsOptionEnum.crCSVExportSectionsOptionExportIsolated

 'Set the export format options with the page range we just set.
 exportOptions.FormatOptions = CSVexportOptions

 Dim oByte() As Byte = CType(GlobalSettings.getInstance().m_RasDoc.PrintOutputController.ExportEx(exportOptions).ByteArray, Byte())
 Dim fout_csv As System.IO.FileStream = New System.IO.FileStream(fileName$, FileMode.Create)

 fout_csv.Write(oByte, 0, oByte.Length - 1)
 fout_csv.Close()

End Sub

KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

SAP Crystal Reports, developer version for Microsoft Visual Studio