Numeric value into English

bbmuskie

Hi,

I'm now creating an Invoice that need to get the Grand Total (a Number field) and convert it to a Total Amount (Text field).

i.e. Grand Total is "3,456,898.23" to Total Amount "Three Million Four Hundred Fifty Six Thousand Eight Hundred Ninety Eight Dollars and Twenty Three Cents Only"

Do I need to create a User Defined Function? If yes, where could I found the reference to create it? Thanks.

thuston

I think someone else asked this previously.
The answer is that BIRT cannot do this, so yes you will have to find some external way to convert the values.
There probably exists a java class you can import that will allow you to do it in a script or DataSet computed column.