[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2854
  • Last Modified:

Adding special characters to a Crystal report formula field

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.

1 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


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now