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

The steps below show how to display boolean true/false values as a checkbox with either 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(254)
    else
    Chr(253)
  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.

 

Similar characters

The following values may also be used

SymbolNameValue
Ballot X251
Check mark252
Ballot box with X253
Ballot box with check mark254

Was this article helpful?

Related Articles