13,251,998 members (57,137 online)
Rate this:
See more:
i created a crystal report in that total amount column Rs 5000.i convert the 5000 to words Five thoushand and xx/100.

how to do.please tell the procedure.
Posted 8-Nov-12 19:57pm
Milind Thakkar 9-Nov-12 1:06am

You mean you are able to convert to "Five Thousand and xx/100" but not able to convert to "Rupees Five Thousand Only" ? If yes, share your current code for people to help you.

Rate this:

## Solution 1

use this,
`'Rupees' + ProperCase(Replace(ToWords (( {sp_AgFinV2Cheque;1.FINALAMT})),’and xx / 100′,’only’))`

For more details
http://datamart.org/2009/06/09/crystal-reports-totext-and-towards-function/

Happy Coding!
:)
Rate this:

## Solution 2

'Rupees ' + ToWords(tonumber({DepositReceipt.Amount}),0) +' Only.'
Member 10660960 7-Mar-17 4:27am

here the lakhs figure not comming out

Top Experts
Last 24hrsThis month
 OriginalGriff 325 Karthik Bangalore 114 ppolymorphe 100 Jochen Arndt 75 an0ther1 65
 OriginalGriff 3,824 Karthik Bangalore 2,151 ppolymorphe 1,529 Dave Kreskowiak 1,301 CPallini 1,240