Plzzz Go thru This -> Crstal Reports

Hi Friend,
I am Using Crystal Report for the repoting Part...
My req is the Total Amount of a Invoice Should Appear on the Invoice as Total Amount In Words too..
eg:-
1000 = Rs.One Thousand Only


I have written a function in Vb which take the Amount in Figure & returns Amount in words...its working fine.

But However i dont find it proper :rolleyes: to save the Amount in Words in the Table..& then display it in the Invoice...

Is There a Way in Crystal Report 7 to Convert Figure To Words...

If yes plzzzzz Help me out....

Thankzzz in Advance..
- Regards Rohan :)

Unfortunately not. Sorry, but Crystal doesn't have anything like this. :(

You could save the data in a variable, registry or text file instead,

ToWords (x), ToWords (x, #places)Arguments

· x is a fractional number to be converted into words.

· #places is a whole number indicating the number of decimal places to be converted. (This argument is optional.)

Returns

Text String

Action

You can use this function to convert a number or currency field value or the result of a numeric calculation to words so it can be used as text. The ability to adjust the number of decimal places can be useful when the number is the result of a calculation that may produce more decimal places than you want.

Typical use(s)

You can use this function to spell out the dollar amount for each check if you are using computer checks.

Example(s)

ToWords(12345)

«Returns twelve thousand three hundred forty-five and xx/100.»

ToWords(12345.6749,2)

«Returns twelve thousand three hundred forty-five and 67/100.»

ToWords(12345.4999,0)

«Returns twelve thousand three hundred forty-five.»

ToWords(12345.5000,0)

«Returns twelve thousand three hundred forty six.»

Heyy Friend,
Thankzzzz a Lot for ur help..
- Regards Rohan