BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Design

Print a checkbox / bullet for a boolean column

Within Crystal Reports, you simply cannot create a checkbox for Boolean operators.  WIth the use of a formula and the Wing Ding font, this task can be accomplished.   If a Boolean field is True or 1, then you can display a box with a check within it, else the box is left blank.

A Boolean field:

True or False
T or F
Yes Or No
Y or N
1 or 0

1. Create a Formula with your column name and type Char(254) for true value and Char(168) for false value.

Example:

If {Orders.Shipped} = True Then
Chr
(254) Else Chr(168);

2. Place the formula within your detail section and refresh (F5)

Results:

Tagged , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

GET SOCIAL

QUICK TIP

You can easily apply font changes to textboxes or fields by simply clicking on them once and selecting the desired font format from the icon menu.

ADVERTISMENT