how to convert currencies?

[pacificpear]

hi all,

In my report i have to convert the currency amount in the currency of the respective country.Default currency is us$.
the report should look like this

India
Customer name order amount order amount ....
in US$ in Rs
Honda $1000 Rs 43000

and so on and i have to show the same thing with all the contries.

can anyone help

thanks
pp

 

[Madawc]

I'd set up a couple of formual fields, which checked the country code and adjusted. Maybe one for the prefix:
If {country} = "UK" then "£" else ...

Another for the conversion factor, @Conv
If {country} = "UK" then 0.666 else ...

Then one for display
{Amount}* @Conv


Madawc Williams (East Anglia, UK)