Thursday, 6 March 2014

Convert Number to Word in Crystal Report

How to write amount in word in crystal report.

Today we are  discussing about to convert amount in word. i mean 12,082.00 in to "TWELVE THOUSAND EIGHTY-TWO ONLY" in Crystal report.



if
right(Totext({@total}),2)="00" then

uppercase(ToWords({@total},0))+" "+"Only"

else

uppercase(ToWords({@total},0))+" AND 

"+uppercase(ToWords(tonumber(right(Totext({@total}),2)),0))+" "+"Paisa 

Only"





0 comments: