Conver number to String!

[#1]

Hi all,

I have a question, hope you help.

I want to convert the number to string.

For example: 120 USD, i want to conver:

0ne hundred and twenty USD

I use Crystall reporter 2008 tools.

Plz help me and give me a example.

Tks!

[Former Member · Accepted solution]

Hi Anh,

You can use Glen suggesting to convert number to words, If you want to add USD after workds please try this :

ToWords()+" USD"

Thanks,

Sastry

[Former Member · Accepted solution]

Hi all,

SELECT T0.[Account], T0.[Debit], T0.[Credit], 
T0.[TransId], T0.[LineMemo],T0.Line_ID,T0.[RefDate],
T1.[Comments] ,T1.convertCurrency
 FROM ORCT T1 , JDT1 T0 
WHERE T0.[TransId]= T1.[TransId] and T0.[ContraAct] ='1111' and T0.Credit<>0 

Note: T1.convertCurrency is a fiel, i created in ORCT table

For example: T0.[Debit] = 1.200.000 VND

i want to convert T1.convertCurrency = one million two hundreds thousand vietnam dong

but I want it to convert to vietnamese language, but not english language

what can i do?

Rgds!

[Former Member]

Hi,

Try: cstr(value,".00") The last part ".00" gives you the option to specify the format at formula level instead of applying the format at field level on the form. That way you're totally in control.

Be sure that the value is not coming null or the field will be blank.

If you want to add text you'll do: cstr(value,".00") & "USD" or whatever text you like before and after the stringed value.

Be seeing you!

Edited by: Marc Garzaran Voyer on Mar 5, 2009 5:26 PM

[Former Member]

Hi Anh

There is a Crystal built in function - ToWords - which should do as you require

ToWords()

Cheers

Glen