CODEWITHSUNDEEP
plsqljasper-reportsoracle-apex
user1945319
user1945319

Reputation:

JasperReports: Convert Amount into Words

I am using iReport 4.7.

I want print amount in words.

For Example:
Assume Text field contains 1000 and i want print like "One Thousand".

Is anyone tell the steps to solve it?

Upvotes: 0

Views: 1541

Answers (2)

Rachcha
Rachcha

Reputation: 8816

If you are using Oracle database then try this:

SELECT TO_CHAR(TO_DATE($P{ParamName}, 'J'), 'Jsp')
FROM dual

This spells out whatever number you pass through $P{ParamName}. You can use this select clause in your main query's SELECT clause and use it.

Upvotes: 0

Bnrdo
Bnrdo

Reputation: 5474

Process your datasource before passing it to the report.

Using ibm's ICU4J you can convert amount into words by doing something like

double num = 2718;
    RuleBasedNumberFormat formatter = new RuleBasedNumberFormat(Locale.ENGLISH, RuleBasedNumberFormat.SPELLOUT);
    String result = formatter.format(num);
    System.out.println(result);

Will print

two thousand seven hundred eighteen

Upvotes: 1

Related Questions