Return the checkmark symbol from a formula

[ellmane]

I am trying to create a formula that returns and puts a checkmark into a Crystal 8.5 text object. The character mapping for this is '0xD6', so I would assume there is some conversion formula that will conver this, but I can't find it. I can go to windows character mapping and get the character, copy it and then paste it into a text object on a report, but I don't know how to produce it in a formula. The formula would then determine, based on a database field if a checkmark or some other character should print. This report is using .NET's version of Crystal and an Access database.

Any ideas would be appreciated. Thanks.

 

[synapsevampire]

Simple way:

Place a text object containing the checkmark (remember that this is font based, so appropriately format it).

Now place the other charcter type formula/field over the top of it.

Use your criteria to conditionally suppress each.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

Hi....this comes from the Crystal Knowledgebase artical C2010279

********************************
4. Create a formula similar to the following:

// (xxx) represents the character you want to display

CHR(xxx)

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

5. Insert the formula into the report.

6. Right-click the @CheckBox formula field, and select 'Font'.

7. From 'Font', select 'Wingdings', and click 'OK'.

**********************

that should sove your problem
Jim Broadbent

 

[ellmane]

Thanks for the tips. Both responses do the trick.