Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Counting Group Footers Post Reply Post New Topic
Author Message
Ssmith
Newbie
Newbie
Avatar

Joined: 02 Feb 2010
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote Ssmith Replybullet Topic: Counting Group Footers
     Posted: 07 Nov 2012 at 5:59am
Hi,
I've got a report that has the following sections:
Report Header
Page Header
Group Header #1
Details
Group Footer #1a
Group Footer #1b
Group Footer #1c
Group Footer #1d
Group Footer #1e
Group Footer #1f
Group Footer #1g
Report Footer
Page Footer
 
and each of the group footers can be suppressed depending on differing criteria.
I'm trying to count the number of times each of the group footers is not suppressed but can't work out how to do this.Cry
 
Does anyone have any idea how I can resolve my problem. I'm currently using CR XI
 
Many Thanks
Stuart.
Stuart
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Nov 2012 at 8:09am
so you are trying to get totals for the report, correct?
You will need one Running Total per footer
each running total will be the same except for the evaluate formula.
 
example.
name=1A_counter
Field to summarize =field you are grouping on
type=distinctcount
evaluate=use a formula
NOT(suppression formula for GF1a goes here)
reset = never
place this in the report footer (RTs will not work in a header)
 
 
repeat and just change each evaluation formula to be
NOT(suppression formula for each group footer)


Edited by DBlank - 08 Nov 2012 at 3:57am
IP IP Logged
Ssmith
Newbie
Newbie
Avatar

Joined: 02 Feb 2010
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote Ssmith Replybullet Posted: 07 Nov 2012 at 10:23pm
Thank you very much. That worked perfectly.
Stuart
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