CR XI csv - Can group header/detail stay separate?
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1144
Printed Date: 05 Apr 2025 at 5:38am
Topic: CR XI csv - Can group header/detail stay separate?
Posted By: vidarroark
Subject: CR XI csv - Can group header/detail stay separate?
Date Posted: 08 Aug 2007 at 11:00am
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 ------------- -E |
Replies:
Posted By: BrianBischof
Date Posted: 08 Aug 2007 at 3:56pm
|
Yes, I just wrote about this in my book on reasons to upgrade to R2. Glad you figured it out.
------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: vidarroark
Date Posted: 10 Aug 2007 at 1:53pm
|
Well.....
I upgraded to release 2, ran through all the updates, and I'm still having the same problem.
Any input/ideas????? ------------- -E |
Posted By: BrianBischof
Date Posted: 10 Aug 2007 at 2:26pm
|
On the CSV export dialog box there is a Mode dropdown list in the middle. Choose Standard for your export. You also have the option of exporting page headers/sections and group headers.
------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: vidarroark
Date Posted: 10 Aug 2007 at 2:31pm
|
I played with those settings and found I had to check "Isolate Group Sections" as well. Thanks!  ------------- -E |
Posted By: BrianBischof
Date Posted: 10 Aug 2007 at 2:35pm
|
Great.
------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |