Crystal XI R2 export to .csv

I have written a Crystal XI R2 SP6 report that looks like this when previewed or printed:

Invoice # Invoice Amount Partner 1 Partner 1 %

Invoice # Partner 2 Partner 2 %

Invoice # Partner 3 Partner 3 %

Invoice # Partner 4 Partner 4 %

Invoice # Invoice Amount Partner 1 Partner 1 %

Invoice # Partner 2 Partner 2 %

etc, with a maximum of 4 partners per invoice, each on a separate detail line and suppressed if the Partner code is empty using a formula but not actually ticking the Suppress box. The incoming record is the invoice broken into separate G/L accounts, so multiple records per invoice, and then joined to the customer table, where the partnership information comes from. I reduce this to one record selected per invoice in the same formula with if Invoice = Previous(Invoice).

When I export to a .csv file it looks like this:

Invoice# Invoice Amount Partner 1 Partner 1 % Partner 2 Partner 2 % Partner 3 Partner 3 % Partner 4 Partner 4 % (This is all on one line although it may not appear that way here)

How can I have the .csv export look like the printed or previewed report? I do realise that I can export it as an .xls file and then save it as a .csv file using Excel, which works perfectly but is not a long term solution for a daily operation in a business.

Thanks for any help you can offer.