Crystal Reports & SQL Reporting Services Training Consultants

Account Log in:

Username:

Password:

*Discover what you really want, by looking at what you envy in others*

Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers

Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog

January

How Do I Display Boolean Values using Symbols in Crystal Reports?

A client recently during a Crystal Reports XI training session, asked "How Do I show boolean values using symbols?

When creating reports with boolean data type, one can use a number of different symbols to represent the true/false value of the field.

Create a new formula
The classic formula, that most use is:

If {Tablename.Fieldname} is True then CHR(0252) Else CHR(0251)
Add the formula to the report
Change the font of the formula to Wingdings

This displays the true value of the boolean as a tick, and the false as a cross.

To enclose the ticks and crosses within boxes, use the following formula:

If {Tablename.Fieldname} is True then CHR(0254) Else CHR(0253)

To display the true value of the boolean as a thumbs up, and the false as a thumbs down:

If {Tablename.Fieldname} is True then CHR(0067) Else CHR(0068)

To display the true value of the boolean as a happy face, and the false as a unhappy face:

If {Tablename.Fieldname} is True then CHR(0074) Else CHR(0076)

To display the true value of the boolean as a closed folder and the false as a open folder:

If {Tablename.Fieldname} is True then CHR(0048) Else CHR(0049)

If you have any questions, or need any assistance, please do not hesitate to Contact Us