A client recently during a Crystal Reports XI training session, asked "How Do I show boolean values using symbols?
When creating reports with boolean data type, one can use a number of different symbols to represent the true/false value of the field.
- Create a new formula
The classic formula, that most use is:
If {Tablename.Fieldname} is True then CHR(0252) Else CHR(0251)
- Add the formula to the report
- Change the font of the formula to Wingdings
This displays the true value of the boolean as a tick, and the false as a cross.
To enclose the ticks and crosses within boxes, use the following formula:
If {Tablename.Fieldname} is True then CHR(0254) Else CHR(0253)
To display the true value of the boolean as a thumbs up, and the false as a thumbs down:
If {Tablename.Fieldname} is True then CHR(0067) Else CHR(0068)
To display the true value of the boolean as a happy face, and the false as a unhappy face:
If {Tablename.Fieldname} is True then CHR(0074) Else CHR(0076)
To display the true value of the boolean as a closed folder and the false as a open folder:
If {Tablename.Fieldname} is True then CHR(0048) Else CHR(0049)
If you have any questions, or need any assistance, please do not hesitate to Contact Us
|
