Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't flaunt your success, but don't apologize for it either
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

24
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.

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

    If {Tablename.Fieldname} is True then CHR(0252) Else CHR(0251)

  2. Add the formula to the report

  3. 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
1

mayavi

21
July
Thanks a lot,it is very helpful...
2

Suresh

26
December
Thankssssssssssss.....
3

Krisl

03
October
It doesn't work for me :( when i put chr(0252) I get Any advice?
4

Julia

03
October
Hi Krisl, Thank you for your comment. Have you changed the Font to either wingdings webdings? Cheers Julia

MAKE A COMMENT

Name *

Email Address *

Comment *