Crystal Report XI R2 - export to .csv not working properly

[Former Member]

Hi Folks,

I developed reports in Crystal Report XI R2 version (with service pack 6) and calling them from Power Builder 11.5. When I export the report to .csv format I see only parameter names with values (supplied to call this report) in csv file.

For eg:

Parameters are

Start Date: 01/01/2012

End Date: 02/01/2012

CompanyID: 21234

Regular output:

colum1 colum2 ...... columnn

data1 data2 ....... data-n

data1 data2 ...... data-n

data1 data2 ....... data-n

..... 10 records

csv output looks like this:

Start Date 01/01/2012 End Date 02/02/2012 CompanyID 21234

Start Date 01/01/2012 End Date 02/02/2012 CompanyID 21234

Start Date 01/01/2012 End Date 02/02/2012 CompanyID 21234

..... 10 records

Please let me know what changes should I do.

Thanks

Indra

[Adam_Stone · Accepted solution]

I would start with providing us with which SDK you are using, is it the .NET SDK or is it COM RDC?

How does the export work from the designer?

You may want to look at th csv export options, specifically around how it exports sections.

[Former Member · Accepted solution]

I am using/calling crystal reports from Power Builder 11.5. I tried with Legacy and standard mode but no luck.

[former_member188030 · Accepted solution]

Perform below steps

- export the report from the CR XI R2 designer, verify the oputput.

- View the report in the CR viewer from the app, verify the output

- Export the report through code using the ExportOptions, check the output.

You may would like to upgrade to CR XI R2 A

15[1598392 - What is Crystal Reports XI R2A and where did all the CR XI R1 and CR XI R2 updates go? |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%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333533393338333333393332%7D.do]

15[1599339 - SAP Crystal Reports XI R2A and CR XI R1, CR XI R2 Fix Packs and Service Packs |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%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333533393339333333333339%7D.do]

- Bhushan.

[Adam_Stone · Accepted solution]

Let me be more specific, look at the value of CharacterSeparatedValuesFormatOptions.GroupSectionsOption. The options are part of the CsvExportSectionsOption enum.