Changing the currancy based on location

[kutoose]

Crystal Reports XI
Business Objects Enterprise XI

Is there any way a currency field can be dynamically changed based on where the user runs the report ?

If the user is in USA, then US dollars is displayed, in Canada, it should be converted to Canadian Dollar and in UK to pounds etc etc.

Thank You

 

[synapsevampire]

The user's system settings should take effect as far as formatting goes.

As for converting values to another currency, this changes hourly, so you'd need a database of the currencies current values, etc, no small chore.

-k

 

[Madawc]

If you can't use the system settings, use a parameter, saying which country's values you want used.

Set currency and currency rate as formula fields. E.g.

if ?Country = "USA" then "$"
else if ?Country = "UK" then "£"

and so on.

The same could be done for conversion rates: pick up the relevant values. If I were doing it, I'd have a system record that held the current currency rates, with a formula field that chose the correct version.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10