How do I check /uncheck a checkbox on crystal report based on values set on the ASP page

Posted on 2007-10-11
Last Modified: 2008-01-09
I have a crystal report that gets populated based on values entered on an ASP form.
Crystal Report version 8.5
I need to display a checkbox on the report. So i ceated a formula field called checkVolunteer
I set the format of the field to Wingdings and set the formula as follows
if (length({?Volunteerpreferenceregion}) >= 1) then
Chr (254)
else Chr(111)

VolunteerPreference is the region the volunteer would like to volunteer, so if the user has entered some information in this field on the ASP form, I need to check the checkbox on the crystal report.

I also tried creating a regular parameter field with a border on all four sides, and then, setting the text value to 'X' or '', that does not work either.
I alos tried setting it in the ASP code to no avail

Could someone please post some sample code if they have done this before.
This is what I got from the Business Objects website
For example:

CHR(254) displays a check box with a check mark in the report and CHR(252) only displays the checkmark without the box in the report.

// CHR(254) - displays a box with a check mark

// CHR(253) - displays a box with an X

// CHR(111) - displays an empty box

// CHR(252) - displays a check mark only

// CHR(251) - displays an X only

Question by:countrymeister
    LVL 100

    Accepted Solution

    Create a formula

    if (length({?Volunteerpreferenceregion}) >= 1) then
      " "

    Put the formula on the report with an appropriate label
    Format the field with the borders

    LVL 1

    Author Comment

    This works with an X fine, but why does the Chr(254) and Chr(111) does not work.
    I will definitely award you the points, since your solution works, just would like to know from a learning point, why the Chr(254) does not work
    LVL 100

    Expert Comment

    I don't know unless either Crystal or your printer doesn't support the extended character set.

    LVL 100

    Expert Comment

    I just found the answer.  You need to use the WingDings font


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    This demonstration started out as a follow up to some recently posted questions on the subject of logging in: and…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now