13,086,264 members (87,951 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
 Graeme_Grant 170 OriginalGriff 138 Jochen Arndt 115 Kornfeld Eliyahu Peter 90 BillWoodruff 80
 OriginalGriff 3,095 Graeme_Grant 1,519 ProgramFOX 1,367 ppolymorphe 1,217 Jochen Arndt 1,205