Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress a header if details are suppressed

Status
Not open for further replies.

lkerr

Technical User
Joined
Mar 2, 2005
Messages
162
Location
US
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!
 
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
 
Can you verify that your detail suppression formula shown above works correctly? What is the content of {@inv}?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top