Converting Currency to obtain total for report

[Guest]

Hello,

My DB has transactions which involves amounts in USD.How would you convert
the USD totals or show both the grand total in usd and the grand total in
another currrency such as a fixed exchange rate for brazillian reias?

Thanks

 

[Tom Lake]

Hello,

My DB has transactions which involves amounts in USD.How would you convert
the USD totals or show both the grand total in usd and the grand total in
another currrency such as a fixed exchange rate for brazillian reias?

Create another field that simply multiplies the USD value by the exchange
rate.

Example:

If you have a control called Total In USD

Add a second control called Total In BRL with the Data Source =[Total In
USD] * 2.827


Tom Lake