Conditional formatting.

I am somewhat new to BIRT so hope this question is not too "duh!"
In our company we are dealing with a multi-currency database and would like to format amounts using the "native" properties for that Currency. Assuming that we have a 100 currency units, then for USD we would present this as 100.00 and for JPY we would present this as 100. (Note no decimal places). I am a user of the Actuate Ereports and this was very simeple to accomplish in that environment but seems to be more difficult in BIRT. Any suggestions are welcome.

Find more posts tagged with

Comments

mwilliams

Hi jlc,

Do you have a column that tells you whether it's USD, etc.?

Also, what version of BIRT are you using?

jlc

The result set gives the various amounts as well as an indicator specifying the number of decimal places. I also get the number of items in a group, the group seperator, and the decimal seperator. So lets assume that the the following items are returned.

Amount 12345678
NumDecimal 2
GroupSize 3
GroupSep ,
DecSep .
The n the displayed amount would be
123,456.78
and if NumDecimal was 3 then the result would be
12,345.678

I suspect that I will finally have to write a clss that all reports will have to use, I was wondering how this is done in the BIRT community so that I do not reinvent the wheel. I have a personal motto "You have eyes, plagerize"

Regards,
Jeremi