Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: CR XI csv - Can group header/detail stay separate? Post Reply Post New Topic
Author Message
vidarroark
Newbie
Newbie
Avatar

Joined: 08 Aug 2007
Location: United States
Online Status: Offline
Posts: 3
Quote vidarroark Replybullet Topic: CR XI csv - Can group header/detail stay separate?
    Posted: 08 Aug 2007 at 11:00am
Ouch 
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

-E
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
vidarroark
Newbie
Newbie
Avatar

Joined: 08 Aug 2007
Location: United States
Online Status: Offline
Posts: 3
Quote vidarroark Replybullet 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
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
vidarroark
Newbie
Newbie
Avatar

Joined: 08 Aug 2007
Location: United States
Online Status: Offline
Posts: 3
Quote vidarroark Replybullet Posted: 10 Aug 2007 at 2:31pm
I played with those settings and found I had to check "Isolate Group Sections" as well.
Thanks!
Big%20smile

-E
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.