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:
Post a Comment