Exporting Text Data to Disk

[MrBillSC]

Sql Server, Crystal vers 9.0
I have a report designed to export data. It exports one text field made up of many concatenated fields. I also have a sub report in the report footer that has the identical layout - one text field made up of concatenated fields.

When I export as type text, all the data including the sub report is exported, but each of the lines of data is broken into 3 shorter lines.

When I export as character separated values, each data line looks complete, but the sub report is not exported.

I have tried moving the sub report to the same group footer (section b) as the rest of the output data, suppressing it if "not onlastrecord", but it is still not exported when I use character separated values.

Any ideas will be greatly appreciated.

MrBill

 

[synapsevampire]

Perhaps you should share what the output is supposed to look like rather than stating what doesn't work.

Does the subreport have one row per row in the main report? Where is the subreport within the main report?

I'd try to avoid using the subreport, so posting your database type and connectivity might help us to eliminate it. Also include some example data.

-k