Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Suppressing a Group Footer Post Reply Post New Topic
Author Message
MikeA57
Newbie
Newbie
Avatar

Joined: 30 Mar 2010
Online Status: Offline
Posts: 11
Quote MikeA57 Replybullet Topic: Suppressing a Group Footer
    Posted: 26 Feb 2015 at 12:10pm
I need to suppress a group footer if records in the group contain one or another identifying code or if it contains neither code. If both codes are present in the group, I need to footer to appear. Can I do this? How?

If:
SRU III appears but SRU I does not, then DO NOT SHOW

SRU I appears but SRU III does not, then DO NOT SHOW

Neither SRU III or SRU I show, then DO NOT SHOW

IF:
SRU III AND SRU I show, Then SHOW THE FOOTER

Thanks,

Mike
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Feb 2015 at 4:37am
one way
create 2 'flag' formulas to count the records rows meeting each condition of the SRU I and SRU III condition.
e.g
//flag1
if table.field ='SRU I' then 1
//flag3
if table.field ='SRU III' then 1
 
Sum each of these flags at the group level
sum(@flag1,table.groupfield)
Sum(@flag3,table.groupfield)
 
Use these two group results in the group footer suppress formula to make it do what you want
example:
NOT(sum(@flag1,table.groupfield)>0 and Sum(@flag3,table.groupfield)>0)
 
IP IP Logged
MikeA57
Newbie
Newbie
Avatar

Joined: 30 Mar 2010
Online Status: Offline
Posts: 11
Quote MikeA57 Replybullet Posted: 27 Feb 2015 at 4:41am
Thanks DB! That is exactly what I just did on my own and it works like a charm.

I was just getting ready to add my solution to this thread.

Is this a case of "Great minds think alike"?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Feb 2015 at 4:43am
glad you got it working Thumbs%20Up
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.012 seconds.