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

Conditionally suppress a text field 1

Status
Not open for further replies.

Bennie47250

Programmer
Nov 8, 2001
515
US
Using Crystal 7.0

Using the formula
If {MyTable.MyField} in ["LD", “LS”] then White else Black to conditionally suppress a text field.

This throws up the error “the formula result must be a boolean”

Tested the syntax in a formula and it is showing True or False so I’m not sure why when using the same formula to conditionally suppress a text field I receive this error.

Thanks for your assistance
 

That formula would work in the Font --> Color formula, but not in the Suppress field formula.

I would move it to the Suppress option, then the formula would be:

{MyTable.MyField} in ["LD", “LS”]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top