Incosistent CSV format download(Crystal Mgmt Console)
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
While running the report from the Crystal Enterprise, we have a file format issue with a Crystal Report which FTP the CSV format file to another server... we recently changed the file format from Excel 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!?...