Solved

ToWords Function in Crystal Report

Posted on 2003-11-05
7
2,196 Views
Last Modified: 2008-02-26
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
0
Comment
Question by:arvind_mvp
  • 2
  • 2
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 9685636
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 9686827
ToWords converts the number to the language of the Crystal edition.  Are you trying to convert to a currency?

mlmcc
0
 

Author Comment

by:arvind_mvp
ID: 9692015
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 9692214
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
 
LVL 77

Accepted Solution

by:
peter57r earned 100 total points
ID: 9692660
'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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports 11 Ignoring Parameters 3 90
Crystal Reports 9 and Subreports 3 78
Exclude some records from totals 10 60
Calculation - Mini/Max Removed then average 8 29
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question