I've looked all over for a solution for this but have found no mention of the issue anywhere.
Simply put, I have a report that has a group header and one or more detail results below the header. When exporting as Excel - data only, the format is fine:
Header Result 1
Detail 1, A, B, C
Detail 2, X, Y, Z
Detail 3, 1, 2, 3
etc....
However, when exporting to a CSV file, regardless of the separator character used, the results are as follows (pipe is the delimiter):
Header Result 1|Detail 1|A|B|C
Header Result 1|Detail 2|X|Y|Z
Header Result 1|Detail 3|1|2|3
etc....
Can I make it so the rows keep the report format as shown here?:
Header Result 1
Detail 1|A|B|C
Detail 2|X|Y|Z
Detail 3|1|2|3
-----------
After looking into this more, I found it's an issue with the version. If anyone else is having this problem, you have to update CR XI to release 2:
http://support.businessobjects.com/downloads/service_packs/crystal_reports_en.asp
Edited by vidarroark - 08 Aug 2007 at 11:56am
IP Logged
