How to convert a number to words (iReport)

Question

I want to convert, for example, 1000 to thousand (currency). How can I do this in Jasper?

Answer 1

• See http://www.rgagnon.com/javadetails/java-0426.html
• Create a class based on this implementation.
• Compile the class and place it in a directory where iReport can read the file.
• Update CLASSPATH in iReport to point to the directory containing the class (be aware of directory associations for package namespaces).
• Restart iReport.
• Change the expression of the text field to: EnglishNumberToWords.convert( $F{field_name} )

You will also need to change the field_namedata type of the method convertaccording to your implementation data.

Answer 2

:

1) RDBMS (, HSQLDB), , , . , (). Java (SQL/JRT) UTC double /.

2) SQL-, , , . , SQL/JRT , .

3) SQL Query ( ) CREATE VIEW (DDL).

4) , View iReport.

: iReports . , iReports.

: JRE ( ) . , , , JRE . SQL/JRT, , RDBMS , , , .