problem to export to CSV file

[huzhou81]

I am using Cystal Report 9.2.2. I have problem to export output into CSV file When I have a header specifid. For example the output should like:

FirstName LastName Salary
fname1 lname1 salary1
fname2 lname2 salary2

but my csv export file looks like

FirstName LastName Salary fname1 lname1 salary1
FirstName LastName Salary fname2 lname2 salary2

In CSV export, I used "," as charactor separtor, no Delimiter, and same number formats as in report.

Anyone know why I got this CSV file export problem, and how to fix it?

Thanks.

 

[Kendel]

You can export it to excel file.

 

[Kendel]

If you must use CSV, you need to take out the header and insert to the CSV file after you export it.