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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
peter57rCommented:
'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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.