12,758,918 members (26,218 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.'

Top Experts
Last 24hrsThis month
 Bryian Tan 190 OriginalGriff 170 ppolymorphe 159 Richard Deeming 150 Graeme_Grant 136
 OriginalGriff 4,327 Peter Leow 3,279 ppolymorphe 2,683 Karthik Bangalore 2,594 Graeme_Grant 2,387