12,550,570 members (40,006 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.'

Top Experts
Last 24hrsThis month
 Dave Kreskowiak 50 Nathan Minier 30 Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 28 ppolymorphe 25 VISWESWARAN1998 25
 OriginalGriff 3,901 Suvendu Shekhar Giri 1,743 John Simmons / outlaw programmer 1,687 ppolymorphe 1,571 Karthik Bangalore 1,210