need to hide a group that is missing specific data

[computek353]

I need to hide the whole group when it is missing specific data. I can hide it if it is missing all of the data but can't seem to selectively hide it.

Help!!!

 

[Foad]

In the section expert, you can specify a suppress condition on a group.

 

[computek353]

Ok I see that but how do I test whether any text is in a field or not?

 

[mbarron]

Use a formula that counts the occurances of the thing you want to be missing.

For example, you want groups that don't have BOB not to be shown.
{@BOB?}
If {field} ="BOB" then 1

Insert the field then perform a summary operation summing the occurances of BOB. Then go to your group select expert and have it only report on groups where Sum ({@BOB?}, {the.group) <> 0.00

You can then delete the {@BOB?} field and the summary field from your canvas. Mike

 

[Ngolem]

in the conditional suppress for both the header/detail/footer sections put the formula

isnull({Table.textfield}) or length(trim({Table.textfield})) = 0


this atches situations when the field has a null value or a blank space