Supress Group Header

[antiskeptic]

I've looked throught the archives and found very similar problems to this, but not exactly what I need, so here goes...and I will try and be as specific as I can...

I am using Crystal 9.0. I have a pretty simple report...three groups, and a detail section that is supressed when a certain field is True. SO All I care about seeing are the "Falses". But then the Group (Department) is still visible even though there are no "Falses" in it's detail section. I've tried to do a summary on the field that has the True / False result...but it says it cannot be summed. So I cann't base the Section visibility on a sum.

Jane Jetson
5/12/04 True
6/07/04 True
5/30/04 False

Betty Rubble
5/12/04 True

(In the above example, I would want to supress Betty and all her details...and be able to see Jane's 5/30/04 record)

I am at a loss and not sure if I'm making any sense. But if anyone knows what I need to fix to make this work, I would be eternally gratefull for a nudge in the right direction.

Thank you, and let me know what other details you need if I've not made myself clear enough.

Sincerely,
antiskeptic

 

[lbass]

Create a formula {@false}:

if {table.field} = false then 1 else 0

Then go to the section expert->group header->suppress->x+2 and enter:

sum({@false},{table.groupfield}) = 0

-LB