Changing Fonts (CR 8.5)

I am trying to display a "Wingding" when a certain value is returned, else display the default font.

In my formula for "Font", I have the following code:

--------------------------------------
if CurrentFieldValue = "1" then
    "Wingdings"
else
    DefaultAttribute
--------------------------------------

But the font doesn't change (ie "1" is displayed instead of an "open folder").  Is there something more I need besides just returning the string "Wingdings"?

(Yes, I have Wingdings font installed on my computer)

TIA
LVL 10
ClifAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DarthModConnect With a Mentor Commented:
PAQed with points refunded (125)

DarthMod
Community Support Moderator
0
 
mlmccCommented:
I tried it in CR8 and it didn't seem to work.  Your formula seems correct.

mlmcc
0
 
MIKESoftware Solutions ConsultantCommented:
Your formula works fine in Crystal Reports XI version......

MikeV
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
MIKESoftware Solutions ConsultantCommented:
You may have WINGDINGS font installed but is it in the correct directory?  Can you change the font to WINGDINGS...without a formula...that is to say...MANUALLY?

right click on the field and change the font to WINGDINGS..Let me know..

MikeV
0
 
mlmccCommented:
I think it may be a limitation of CR 8

mlmcc
0
 
ClifAuthor Commented:
CRXIuser2005,
Yes, I can manually change the font to Windings.
0
 
ClifAuthor Commented:
Ok, it looks like it will work going the other way.

In other words, if I make the field's font "Wingdings" and use the following code it works:

--------------------------------------
if Trim (CurrentFieldValue) <> "1" then
    "Arial (Western)"
else
    DefaultAttribute
--------------------------------------

Not sure if this warrants awarding a grade, though...
0
 
ClifAuthor Commented:
I was looking at my most recent code and the list of fonts that Crystal provides and noticed that there are two entries for Wingdings:

"Wingdings"
and
"Wingdings (Symbol)"

I put my code back, but changed "Wingdings" to "Wingdings (Symbol)" and it now works.

--------------------------------------
if CurrentFieldValue = "1" then
    "Wingdings (Symbol)"
else
    DefaultAttribute
--------------------------------------

How annoying is that?
0
 
ClifAuthor Commented:
mlmcc,
Who would I award the points to?  No one actually gave an answer that worked.
0
 
mlmccCommented:
In that case I can close this and refund the points.

MikeV - Any objections?

mlmcc
0
 
brainsprocketCommented:
Ah clif, it's not always knowing right answers, but asking the right questions...

brainsprocket
0
 
ClifAuthor Commented:
Thanks.  :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.