Euro symbol

[shb46]

Have a requirement to either change the currency symbol on the fly based on the value of a field e.g if dbname.currency = EUR then symbol reported is € , else £ or whatever - CAN THIS BE DONE.

or
display a formula field that contains the currency symbol based on similar construct.

being greedy - my printer details the euro symbol using word but when I change ite default currency symbol within Crystal to Euro € (ctrl, alt $) it displays correctly on the screen but not on the printer. Any ideas folks?

All help appreciated. thanks.

Currently using Version 7

 

[kenhamady]

You can set the currency symbol within CR to print conditionally. If you format the field and look at the currency symbol tab, which is under "Customize" in V8.x. There is a formula button.

You put in a formula like:

If {Cur} = "USD" then "$" else
If {Cur} = "YEN" then "¥" else
If {Cur} = "BPND" then "£" else .... Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.