Sage 100

I'm trying to export a Crystal report that has two detail sections to a CSV file but it is combining the two sections onto one line. I've tried changing the options to not export sections, to isolate sections, etc. but nothing is helping. What am I missing??

There may be another way, but my first thought is to use a formula field, building the line output into a single field, similar to how Sage builds address fields in forms.

Hmm, so have it all in one section but use formulas to make it two lines?? Will give it a shot!

Good thought but that didn't work either.

Try exporting as text instead of CSV... building your delimiters into the formula.

Can one of the detail lines be a group header? That should export as separate lines.

I think the text option will work! Good thought on the group header @ScottFirgens !

The group option works if I isolate the sections - thanks @ScottFirgens !