Crystal Report CSV format issue

[Former Member]

Hi Experts,

At present, we are using Crystal Reports & Crystal Enterprise. Below is our Crystal Report version details..

1. Software: Crystal Reports (CR Developer)

Product type: full

Version: 9.2.3.1011

2. Software: Crystal Enterprise Enhanced SAP Edition 9

3. Software: Crystal Enterprise

version: 9.0.1.314

We have a file format issue with a Crystal Report which calls SAP Function Module to generate the data and FTP the CSV format file to another server... As excel download format not suitable to our requirements, we recently changed to CSV format., initially when we tested its worked fine. But, now the same report exporting file in 2 different formats in different runs. Its not consistent.

For Example : in the correct CSV file, the report data exported as page header followed by commas(',') then data continues in the same line( ex: "OPSurgeon",,,"1")..

where as in wrong CSV file format, the report header exported without commas(',') separator after the page header(ex: "OPSurgeon" "1") this resulting report data split into 2 records..

Please let me know why sometimes there is a difference in the CSV file format??... Also, please let me know if we have any chance to remove the Report Header downloading in everyline!?...

As this is the Production issue and effecting the downstream systems in processing data, Please reply back asap.. Thanks

Kind Regards,

Bhasker Rao

[Former Member · Accepted solution]

Hi Bhaskar,

This forum is dedicated to topics related to the BusinessObjects [Integration Kit for SAP|;

It is monitored by qualified technicians and you will get a faster response there.

Also, all SAP Kit queries remain in one place and thus can be easily searched in one place.

I hope this helps you.

Regards,

Shweta

[Former Member · Accepted solution]

Shweta?

This is the Crystal Reports Design forum.

Not the integration kit forum.

If this issue is occurring in Enterprise/Infoview there is a Business Objects Enterprise forum that may be more applicable.