Supress Group

[kate8]

Hi,

I have a Crystal Report that I need to supress the whole group if any record in the group does not match the condition. For example, a person has three records under his name. if any of his record does not match the condition,this person won't be showed in the report. IS THIS POSSIBLE???

Thank you for any help!!!

 

[ianoctdec]

Hi kate8,

create formula:

@MatchCount

if <record matches condition here> then
1
else
0

Then insert a summary on this formula at group level.
In record selection formula by group add <Group summary> = 0

Dana

 

[kate8]

Dana,

Thank you so much for you help. The whole idea works well. I set
if <record matches condition here> then
0
else
1
since I don't need that group if any record does not match the conditions.
Thanks a lot!!! I almost gave up this Crystal Report.

I have another question, could you also help me with this?

If the subreport is empty,I don't want it to be showed. I tried to do "Suppress Blank Section" from Section Expert, but doesn't work.The empty subreport still show. I only have 4-10 records every time, but got more than 80 pages report.
How can I hide the empty subreport?
Thank you!!

Kate

 

[lbass]

You need to format the subreport->format subreport->subreport tab->suppress blank subreport. You should also remove the borders as well as formatting the section it is in to "suppress blank section".

-LB

 

[kate8]

lbass,

Thanks a lot!!! I got it.