Suppress a header if details are suppressed

[lkerr]

HELP! This should be easy, but for some reason, I just can't get it to work! What I am trying to do is suppress the Group Header when the everything in the details section has been suppressed. What I have done so far is create a formula that pretty much echoes the detail suppression formula that should give me a non-zero if there are non-suppressed fields and a zero if there are only suppressed fields. The problem is it isn't working that way. Here are the formulas I have so far:

@inv: a concat formula combining two dates which, if empty, means we haven't invoiced yet.
Detail suppression: if {@inv} = "" then true else false
@there? formula: if {@inv} = "" then 0 else 1

Then I'm doing a sum on the @there? formula (with the idea of suppressing the zeros), but I'm getting a non-zero on EVERY field! What am I doing wrong? HELP!

Or, does anyone know a better way? Thanks!

 

[synapsevampire]

Perhaps it's a null concern, hard to know since you didn't bother to post what's in the key formula: @inv

Take time to post requirements, rather than discussing them.

Try checking for mull, otherwise post technical information:

Or perhaps you need to sum the @there to determine, it's too hard to say from a text description.

Post environment and requirements:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[lbass]

Can you verify that your detail suppression formula shown above works correctly? What is the content of {@inv}?

-LB