amount to letter in crystal report
-
I would like to convert the amount to letter in crystal report, I use the "towords" but a number like 123.23 that gives me one hundred twenty-three 23/100, somebody who can help me thank you
-
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it. My latest tip/trick - Silverlight *.XCP files. Visit the Hindi forum here.
thank you very much for your help, I found a solution but it is not complete. I used this formula:
if
right(Totext({amount}),2)="00"
then
uppercase(ToWords({amount},0))+" "+"Only"
else
uppercase(ToWords({amount},0))+" AND "+uppercase(ToWords(tonumber(right(Totext({amount}),2)),0))+" "+"Paisa Only"the resultat of this numbre 1186,86 is: THOUSAND ONE HUNDRED NINETY-SEVEN AND NINETY-SIX Paisa Only how can I correct this error, how can I convert it as it is, thank you in advance