Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Multiple running group totals Post Reply Post New Topic
Author Message
njs41823
Newbie
Newbie


Joined: 14 Apr 2014
Online Status: Offline
Posts: 1
Quote njs41823 Replybullet Topic: Multiple running group totals
     Posted: 14 Apr 2014 at 12:38pm
Say I have a report that looks like this in preview:

a
a
b
b
b
d
d
e
f
f
g,

where the data is grouped as shown.  I would like to have running counts placed after the list, like so:

a
a
b
b
b
d
d
e
f
f
g

a: 2
b: 3
c: 0
d: 2
e: 1
f: 2
g: 1.

Is there an easy way to do this, other than to create a running total for each individual letter (a,b,c,...,g)? 

Furthermore, supposing that 'c' is a possible value in the data that isn't being selected, how can I create the running totals so that any total with a value of 0 does not show up (in the above case, "c: 0" would not show up)?

Any and all help is greatly appreciated.  Thanks!!


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Apr 2014 at 4:09am
from your example you just have to group on the field and insert a count of the field at the group level and place the count in the group header then suppress the details and group footer.
Since "c" is not a value in your example dataset it will not be shown.
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