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

Changing Boolean display values 1

Status
Not open for further replies.

knulisch

Programmer
Oct 10, 2000
18
US
I have a boolean field on a report. When the value is true I would like to display "Disqualified" and when the value is false I would like to display " ". How do I accomplish this?

Thanks [sig][/sig]
 
Put a formula in place of the boolean:

if {field}
then "Disqualified"
else ""

this assumes that Crystal recognizes the field as a boolean. if it recognizes it as a character or a string you may have to change the if condition. [sig]<p>Ken Hamady- href= Reports Training by Ken Hamady</a><br>[/sig]
 
Thanks for your help - that worked great! [sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top