Crystal Report CSV format issue
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
2. Software: Crystal Enterprise Enhanced SAP Edition 9
3. Software: Crystal Enterprise
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
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.