12,451,227 members (53,485 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
 ppolymorphe 174 Richard MacCutchan 110 OriginalGriff 65 Karthik Bangalore 55 Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 50
 OriginalGriff 6,053 ppolymorphe 3,595 Karthik Bangalore 3,500 Maciej Los 3,005 Richard Deeming 2,830