12,395,117 members (67,246 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
 OriginalGriff 215 ppolymorphe 165 Richard Deeming 120 Jochen Arndt 110 Richard MacCutchan 90
 OriginalGriff 5,998 Karthik Bangalore 2,382 ppolymorphe 2,350 F-ES Sitecore 1,877 Richard MacCutchan 1,707