1573513 - How to display amount in words in crystal designer?

Symptom

Displaying amount in words in crystal designer

Cause

'Towords' formula display only integer part. for example if we try to display 86.15 amount, how ever it shows only integer part like eighty six and display dacimal part like 15/100

Resolution

if tonumber(mid(totext(567.97),(instr(totext(567.97),'.')+1))) > 0 then
propercase(towords((567.97),0))&" Rupees and "&
propercase(towords(tonumber(mid(totext(567.97),(instr(totext(567.97),'.')+1))),0))&" Paise Only"
else propercase(towords((567.97),0))&" Rupees Only"

Keywords

Amount, amount in words , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports all versions