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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

suppressing detail with both true/false values

Status
Not open for further replies.

77walker

Technical User
Feb 7, 2008
33
US
I have detail that can show up with both true or false values, however if one value equals true than I need to suppress both detail records. Can anyone tell me how to do that in crystal XI?
 
You mean that you want tu Suppress the Details section if at least one of the record has a value of true in a specific field?

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium
 
If you mean you have two or more details within a group and you want to suppress the entire group if one of the details has a true value, then write a formula like this {@true}:

if {table.field} = true then 1

Then go to report->selection formula->GROUP and enter:

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

This would display only those groups containing no true values.

-LB

 
LB,

Thank you that worked beautifully, I'm still relatively new and everything I read on this site has been so helpful.

-LW
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top