Adding Additional Currencies to Ad-Hoc Domains

Overview

This short article describes how to add additional currencies to ad-hoc reports. This doesn't cover something like a generic currency field which is on the spot converted to the user's current Locale-  (you can do that by developing a Groovy function though!)This assumes you have fields like amount_usd, amound_euro, amoung_gbp and want to assign a different mask to the field like $, €, or £

How-To

You will need to edit the locale file that is associated with the locale that you want to edit. In my case I want to edit the default locale so I edited the file /webapps/jasperserver-pro/WEB-INF/bundles/adhoc_masks.properties if you wanted to edit the spanish one you would edit adhoc_masks_es.properties

Add the additonal currencies like you see here for integers and decimals:

See Also

End Result

Here's an example in ad-hoc, this will also export properly to PDF, etc