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

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
0
Clif
Asked:
Clif
  • 5
  • 3
  • 2
  • +2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
DarthModCommented:
PAQed with points refunded (125)

DarthMod
Community Support Moderator
0
 
ClifAuthor Commented:
Thanks.  :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now