CharacterSeparatedValuesFormatOptions Is ignored

[Former Member]

Hello,

Here is some sample VB.net code where I can not get CR 2008 to use the options in CharacterSeparatedValuesFormatOptions. Does anyone see what I am doing wrong?

Sub Main()

Dim crReportDocument As New ReportDocument()

Dim crExportOptions As New ExportOptions()

crReportDocument.Load("C:\temp\quotetest.rpt")

Dim CVSoptions As CharacterSeparatedValuesFormatOptions

CVSoptions = ExportOptions.CreateCharacterSeparatedValuesFormatOptions()

crExportOptions.ExportFormatType = ExportFormatType.CharacterSeparatedValues

Dim crDiskFileDestinationOptions As DiskFileDestinationOptions = ExportOptions.CreateDiskFileDestinationOptions()

crReportDocument.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile

CVSoptions.Delimiter = "%"

CVSoptions.SeparatorText = "#"

crReportDocument.ExportOptions.ExportFormatOptions = CVSoptions

crDiskFileDestinationOptions.DiskFileName = "c:
temp
CharacterSeperatedValues.rtf"

crExportOptions.ExportDestinationOptions = crDiskFileDestinationOptions

crExportOptions.ExportFormatOptions = CVSoptions

crExportOptions.ExportFormatType = ExportFormatType.CharacterSeparatedValues

crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile

crReportDocument.Export(crExportOptions)

End Sub

Thank you in advance for your help.

Zeller

[former_member183750]

Make sure you are on SP3:

https://smpdl.sap-ag.de/~sapidp/012002523100007123572010E/cr2008_sp3.exe

MSM

https://smpdl.sap-ag.de/~sapidp/012002523100007123582010E/cr2008sp3_mm.zip

MSI

https://smpdl.sap-ag.de/~sapidp/012002523100007123592010E/cr2008sp3_redist.zip

Couple of Kbases that may help you:

[1337119 - CR .NET SDK export to CSV format is missing data|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333333333337333133313339%7D.do]

[1449453 - How to export a Crystal Report to CSV format using the RAS SDK?|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333433343339333433353333%7D.do]

Oh - and have a look at these:

http://help.sap.com/businessobject/product_guides/boexir31/en/crsdk_net_dg_12_en.chm

http://help.sap.com/businessobject/product_guides/boexir31/en/crsdk_net_apiRef_12_en.chm

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

Edited by: Ludek Uher on May 13, 2011 10:33 AM