12,950,284 members (73,293 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 18: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 485 CPallini 295 Maciej Los 250 CHill60 185 F-ES Sitecore 165
 OriginalGriff 5,829 CHill60 3,460 Maciej Los 2,953 Jochen Arndt 1,975 ppolymorphe 1,820