Crystal Reports – How to display boolean true/false as tick

The steps below show how to display boolean true/false values as a tick and/or cross.

By default these values are displayed as either ‘True’ or ‘False’.

crystalreports-booleantick1

  1. In the Field Explorer right-click on ‘Formula Fields’ and choose ‘New’
  2. crystalreports-booleantick2
  3. Enter a name for the formula, e.g. tick_user_likes_fruit
  4. Add in the following formula (replace {Sheet1_.user_likes_fruit} for your field)
  5. if NOT ISNULL({Sheet1_.user_likes_fruit}) AND {Sheet1_.user_likes_fruit} then
    
        Chr(252)
    
    else
    
        Chr(251)
  6. Save and close the window
  7. Add the formula field to the report.
  8. Change the font for the field to Wingdings.
  9. The field will now display ticks and crosses that correspond to the boolean value.
  10. crystalreports-booleantick3

 

Similar characters

The following values may also be used

Symbol Name Value
Ballot X 251
Check mark 252
Ballot box with X 253
Ballot box with check mark 254