Tip: How to Print a CheckBox for a Boolean Column in Crystal Reports?

Crystal Reports does not provide a CheckBox conrol. This small tip shows how to create a CheckBox for a boolean column in Crystal Reports.

I have to display a CheckBox for a Boolean column in Crystal Reports. If the value of the column is true, the CheckBox should be checked, otherwise unchecked. Unfortunately, Crystal Reports does not provide a CheckBox control.

 

The workaround for this is:

 

Create a Formula with your column name and print Char(254) for true value and Char(168) for false value. Here is my formula look like:

 

If {Table.IsTeacher} = true then Chr(254) else Chr(168)

 

Now place the formula in your report designer and change font to Wingdings. You are all set.

 

This is amusing, how Business Objects folks (creator of crystal reports) can't just provide a control, which does the same. May be they will have in next version ;-)