Link to home
Start Free TrialLog in
Avatar of arvind_mvp
arvind_mvp

asked on

ToWords Function in Crystal Report

Hi..
    I have used the ToWords function crystal report to convert from amount to words ....Suppose in give as ToWords(100000)
The result is One Hundred Thousand...Instead i need the result to be One Lakh....How to get it
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Not enough information to give you a proper answer.

But, in principle, you could run a Replace function on the result of the ToWords function.

For example:

You have a formula field mWords:

stringvar resp;
resp := ToWords ({Orders_Detail.Order ID});
resp := Replace (resp,"thousand" ,"Lakh" );
resp

repeat the Replace command for all the changes you want to make.

Pete
Avatar of Mike McCracken
Mike McCracken

ToWords converts the number to the language of the Crystal edition.  Are you trying to convert to a currency?

mlmcc
Avatar of arvind_mvp

ASKER

I dont want to convert to a currency...what i need is just conversion to words...is there any version of crystal edition which converts currency to the format i wanted ( ie Asian Format)
I didn't know what Lakh was.

Are yo trying to display the words in another language?

I believe you will need to buy the appropriate langauge edition.

You could also write your own function to do the conversion.

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial