Adding special characters to a Crystal report formula field

Posted on 2007-08-08
Last Modified: 2013-11-26
Hi all,

How can I add a "check mark" to a formula field's text?

I need to put a check mark on my reports fields, something like this:

"Read/Write" - V
"Delete" - X

I know how to do this, I just don't know how to add the check mark character.

Question by:nahumba
    1 Comment
    LVL 9

    Accepted Solution

    - Create a separate formula to display the check mark. The formula can be something like this:
       if {@FormulaField} = 'Read/Write' then 'P' else if  {@FormulaField} = 'Delete' then 'O'

    - Place the formula somewhere in the report, give it some symbolic font (in my example, WingDings2 should show checkmarks for 'O' and 'P')
       If you like some other font and/or character better, just use that...
    - Add an empty text field to your report
    - Drag your text formula into the text field
    - Drag the CheckMark formula into the textfield


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
    This is about my first experience with programming Arduino.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now