Function Calling

[pashu]

Hi Freinds,

I've written the function to convert figures into words in vb 6.0 and by passing the amount value to the function i'm getting the figures in words and storing in database and printing on the report.
But now i'm desingning one such report by writing the query and executing the report with the help of this query.Here i too wanted to convert my figures into words,as my function is written in vb how do i do that in crystal reports.My backend is oracle 8i.Pl. suggest its urgent.
Thanks in advance.

Regards,
Prashant.

 

[lbass]

Not exactly sure if this is what you are asking, but...in Crystal Reports, use the "towords" function:

towords({table.amount})

This will give you something like the following for $1199.13:

one thousand one hundred ninety-nine and 13/100

-LB

 

[pashu]

Hi LB,

I knew this function but i want the amount to be spell in lakhs if the amount is in lakhs,the above funciton reads in thousand.For eg.100,000 this amount i want to read say "Rupees One Lakh " whereas the towords() function read as "Dollar Hundred Thousand" that's the problem.I'm staying in India so it should be Rupee not dollar.

Thanks,
Prashant.

 

[lbass]

Your original post said nothing about wanting to convert to another language, but the following thread might be helpful to you: thread767-531841

-LB