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

A formula that is placed on a report is indicated by the @ prefix (for instance, @Name).

ADVERTISMENT