CSV problems

[Bloke152]

Crystal 9

Hi guys.
Im getting an unwanted extra comma when exporting to CSV from Crystal. I have the report running from a command with the column names in a union as our version of crystal doesnt work properly when exporting to CSV.

The exports im getting are like below but i want the last comma not to be there.

"Catalog_no","Catalog_desc","Form","Pack","BAG Weight","Pallet Weight",
"P1604","DB Plate 1000 SD6 bulk","SD","BULK","","",

Im a bit confused becuase this is one of 4 reports i have done like this in the past week and this is the only one that is putting this comma on the end. Anybody got any ideas as to why? Any help would be appreciated. If you want any more info just give me a shout

Cheers

 

[Bloke152]

Solved the problem!

it would seem that it was being caused because my data was in a group header and not the details section. So to remedy this im going to group in my command rather than on the report.