Crystal Report: Convert Amount to Words

Report Application: Crystal Report

Version: 2013

Scenario:

I have a field {ARIBH.AMTNETTOT} that has amount in figures and the client needs the amounts in words

Solutions

//extract Naira  only

Propercase(ToWords(truncate({ARIBH.AMTNETTOT}),0) + ‘ Naira and ‘ +

//extract the Kobo and convert to words Another formula for rounding up.
ToWords(remainder({ARIBH.AMTNETTOT}*100,100),0) + ‘ Kobo Only.’)

 

Do have a lovely day

Leave a Reply