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
arvind_mvpAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
'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 don't think there is a version of CR which converts CURRENCY to words in any language or any currency.
It only converts numbers to words.
There is a procedure here which shows how (difficult it is!) to convert dollar amounts to words including currency.
http://support.crystaldecisions.com/library/kbase/articles/c2005712.asp

Pete
0
 
peter57rCommented:
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
0
 
mlmccCommented:
ToWords converts the number to the language of the Crystal edition.  Are you trying to convert to a currency?

mlmcc
0
 
arvind_mvpAuthor Commented:
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)
0
 
mlmccCommented:
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
0
All Courses

From novice to tech pro — start learning today.