Multiple currency symbols in crystal 9?

[jambu]

I have a report that I want to show a number of different currency symbols. I have used the currency formula button to change between euros and sterling before but am not sure how I can show Krona, Baht, Zlotys or any other combination of symbols.

Can anyone answer some of the following questions?

1) Can crystal 9 display all currencies and if so can it combine multiple symbols in the same report?

2) If not can this be done in version 10?

3) Does 9 support unicode?

Many thanks.

 

[synapsevampire]

Yes, CR 9 was the first Unicode compliant version.

Go into the X2 next to the Currency Symbol and use a formula to change the symbol, as in:

if {table.currency} = "USA" then
"$"
else if {table.currency} = "EURO" then
"Euro"
else if {table.currency} = "blah" then
"whatever"
... you get the idea

Now if you're speaking of altering the way that currency is displayed, as by altering the thousands character, etc., that will require a formula there as well.

-k

 

[jambu]

Thanks for your reply, that is roughly the stage I am at.
I really need to know how to get the currency symbol as in 'é' for Euro but for any currency.

I would think it would look like this...

if {table.currency} = "USA" then
"$"
else if {table.currency} = "EURO" then
"é"
else if {table.currency} = "SFR" then
chr('number in here that corresponds to the swiss franc symbol')

I don't know where to get a table of currency values.