Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report group by issue Post Reply Post New Topic
Author Message
ace213
Newbie
Newbie


Joined: 13 Apr 2010
Online Status: Offline
Posts: 2
Quote ace213 Replybullet Topic: Report group by issue
    Posted: 03 Aug 2011 at 9:13am

Hello,

 
I'm trying to design a crystal report that will have the following structure:
 
( Group 1 Header) Account: 001
      
       ( Group 2 Header) Dept: ABC
                            Line Totals
       (Group 2 Footer )  Total ABC
 
        (Group 2 Header) Dept: EFG
                            Line Totals
        (Group 2 Footer) Total EFG
 
       ( Group 2 Header) Dept: HIJ
                            Line Totals
       (Group 2 Footer )  Total HIJ
 
        Total ABC
        Total EFG
        Total HIJ
 
(Group Footer 1) Account 001 Total
 
Is there a way I can display the Group 2 Totals ( highlighted in red) in the mentioned way, just above the Group 1 footer? Any help will be greatly appreciated.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 04 Aug 2011 at 3:50am
you could use a subreport
 
you could try shared arrays (which I haven't done...the subreport is probably easier)
 
nothing else really comes to mind as viable.
 
HTH
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 Aug 2011 at 4:18am
maybe make your RED ink as group Footer 1A and insert a crosstab and move 'Account 001 Total' to Group Footer 1B
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 04 Aug 2011 at 8:53am
keep forgetting about that Cross-Tab in the group footer....excellent suggestion DBlank.
 
I don't tend to have a need for that, so I keep forgetting
 
IP IP Logged
sreenu435
Newbie
Newbie


Joined: 15 Jul 2011
Online Status: Offline
Posts: 10
Quote sreenu435 Replybullet Posted: 07 Aug 2011 at 11:19pm
use running totals you can get the above results
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.015 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.