Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crosstab Total Post Reply Post New Topic
Author Message
emily
Newbie
Newbie


Joined: 04 May 2012
Online Status: Offline
Posts: 2
Quote emily Replybullet Topic: Crosstab Total
     Posted: 04 May 2012 at 2:47pm
Can anyone tell me how I can exclude a zero in a cross tab total? I will give the following example to illustrate what I mean.
I want only to see the totals that are not zero.
Thanks in advance.
 
              ACTUAL Cross Tab
          C1            C2            C3       Total
R1 100 -80 10 30
R2 150 -100 -50 0
R3 200 -50 0 150
R4 300 -200 -100 0
750 -430 -140 180
                 DESIRED Cross Tab
           C1            C2            C3        Total
R1 100 -80 10 30
R3 200 -50 0 150
300 -130 10 180
IP IP Logged
amanda5615
Newbie
Newbie


Joined: 20 Apr 2012
Location: United States
Online Status: Offline
Posts: 17
Quote amanda5615 Replybullet Posted: 07 May 2012 at 9:11am
The only way I can think of this would be to create a formula that adds all field together, we will call it "GRAND Total", then use your selection expert on the main report to say Grand Total is greater than 0.
If you need the raw data in the bottom of the report, then I would recommend using a sub report to make the cross tab.
IP IP Logged
emily
Newbie
Newbie


Joined: 04 May 2012
Online Status: Offline
Posts: 2
Quote emily Replybullet Posted: 07 May 2012 at 12:03pm
Many thanks for your feedback. I will try them.
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.