Am I am to add a checkbox? 4

[ksbigfoot]

I have a field that is either 'Yes' or 'No' or '1' or '0'. I would like to have a checkbox with a check in it.
Are checkboxes available in Crystal Reports?
Thanks

 

[MrBillSC]

You can create a fake check box with a formula:
//formula ckbox
If {table.field} = 1 then
"X" else " "

Place the formula where you want it and set it borders to a single line. Shrink the field size to the size you want the box. If there is a way to change the "X" to a check mark, I would like to know that as well.

MrBill

 

[Turkbear]

Hi,Even more fun try:
//chkbox
if {table.field} = '1' then chr(254) else chr(168)
Then format this field in your report to use the Windings font..
It will prodcue a checked or unchecked little box.

 

[ksbigfoot]

Hi MrBill & Turkbear,
I will give that a try and let you know what I come up with.
Thanks again for your help.
p.s. I should read my titles before I post a question, opps :>

 

[ksbigfoot]

I am a little confused as I am new at this.
I created a formula and tried both of these lines:

if {v_ECL_LocalAuthorities.Emergency911} = '1' Then chr(254) else chr(168)

if {v_ECL_LocalAuthorities.Emergency911} = '1' OR {v_ECL_LocalAuthorities.Emergency911} = 'Yes' Then 'Happy' else 'Sad'

The field I dropped onto my report is not being updated.
Do I have a say something like {v_ECL_LocalAuthorities.Emergency911} = 'Yes'?

 

[ksbigfoot]

Hi MrBill & Turkbear,
Thanks again. I didn't drop the formula onto my report.
As soon as I did, it worked perfectly. Here is the code I used.
Thanks again, star to you.

If IsNull({v_ECL_LocalAuthorities.Emergency911}) Then
  chr(168)
Else
    If {v_ECL_LocalAuthorities.Emergency911} = '1' OR {v_ECL_LocalAuthorities.Emergency911} = 'Yes' Then
      chr(254)
    Else
      chr(168)