I am currently setting up a crystal report to use with ACCTivate which is an ERP system. The problem that I am having is that one of our rather large clients wants their invoice history in csv format every month, I got it to export fine I know how csv is formatted and I understand why we're doing it, the problem I have is I need a line break put in the details field.

ex.

Header data price   number
Line   cust line    quantity

this is how it's displaying in CR XI, this is correct I need it to look this way, however this is how it's coming out in csv format

header data price number Line cust line quantity

I need a line break after number however when it exports to csv it just keeps all of the detail field on one line, and yes i have detail a, detail b fields set up for the two different lines..

Any help would be greatly appreciated.

Thank you for your response I will try it but I just fixed the issue. What I did was I put Header in a group header and put LINE in the details for that group and that also fixed another issue where i had multiple LINES per HEADER but thank you I am probably going to use this shortly