Convert Numbers into Words in Crystal 8.5

[krist]

Hi,

I want to print Invoice with Crystal Report 8.5 and MSSQL 2000, for that I need to convert the Total Amount of the invoice from Numbers into Words, e.g :
'One Million Seven Hundred ..etc...',
BUT in our LOCAL language, NOT english.

Where should I put the conversion subroutine, in Crystal Formula or in MSSQL Function/Procedure ??

Thanks in Advance,
Krist

 

[kenhamady]

You might want to write a UFL so you can easily use it with any number, like a function. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[BakshG]

This can be done very easily while you create a report. Just go to create a new formula in report design view then find a formula called: ToWords, it is localed under String Functions

 

[kenhamady]

BTW what language are you trying to use?
CR has some non-english editions. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[krist]

Ken,
Hopeless, I want to use Bahasa Indonesia

Krist