Crystal Reports ToText and ToWards function

12 Responses so far.

1. Razan says:

   July 23, 2009 at 2:41 am

   i need to know if i can use the to word function to convert numbers to chinese word characters?
2. mahesh says:

   April 7, 2010 at 10:18 am

   hi. I am used Crystl report.how to print towords in the value 2,45,545.
3. mahesh says:

   April 7, 2010 at 10:32 am

   Hi,
   I need help in crystal reports Check printing. While printing number in words it is printing 3,65,945.00 .
   i want words in ” THREE LACKS SIXTEFIVE THOUSAND AND NINE HUNDARD AND FORTY FIVE ONLY”.
   I WANT FORMULA.
   THANKS
4. Prageeth says:

   April 9, 2010 at 12:47 am

   write funtion
   Ex:
   ToWords(Invoice.Value)
5. mahesh says:

   April 19, 2010 at 10:03 am

   hi ! i am used vb.net+msAccess.
   i m user crystalreport.
   how to Export to CrystalReport To Tally9.
   if its possiable? pls help me.
   my email id: vmahee@gmail.com.
6. KSKarthikeyan says:

   April 20, 2010 at 11:44 pm

   Hi,

   You can follow the below example of ToWord Function.

   ProperCase(Replace(ToWords (( {sp_AgFinV2Cheque;1.FINALAMT})),’and xx / 100′,’only’))
7. Raj Kumar says:

   May 2, 2010 at 6:54 pm

   Hello Sir,

   I am Rajkumar.working in SAP B1.for that i have to work in crystal reports.i am having doubts in crystal reports(Formula fields).
   Please guide me to get knowledge in formula fields.especcially i want to know, how to convert Number into words(Convert into Indian Rupee).

   please do the needful.

   Please Mail me , that if you have any pdf for formula fields.

   Thanks & Regards
   Rajkumar.k
8. admin says:

   May 15, 2010 at 12:09 pm

   You have to create 2 formula fields as follows
   1- ProperCase (‘Indian Rs’) This field is created in the Crystal formula.

   2- ToWords ({StoredProcedure3_1;1.Salary}) – This field is a Salary field.

   Then you can put these 2 fields in your report. I fyou find another alternative solution please let us know.
9. Farhan Rana says:

   August 26, 2010 at 1:17 am

   I need help in crystal reports 8.5 Check printing. While printing number in words it is printing 3,65,945.60 .
   i want words in ” THREE LACKS SIXTEFIVE THOUSAND NINE HUNDARD FORTY FIVE RUPEES AND Sixty Paisa ONLY”.
   I WANT FORMULA.
   Plz Mail me immediately at
   rana_farhanr@hotmail.com
10. Hoysala says:

    October 21, 2010 at 9:47 am

    Towords function

    ToWords is resulting in as one hundred twenty three and 10 / 100
    its not showing cents in words
11. Hoysala says:

    October 21, 2010 at 10:12 am

    Hello mahesh, Raj Kumar, admin and Farhan Rana.

    Use the below formula it works fine for Indian Ruppees.
    But please tell me how to convert number into US Currency words where last 2 decimal should be framed as cents in words

    numbervar RmVal:=0;
    numbervar Amt:=0;
    numbervar pAmt:=0;
    stringvar InWords :=”Rupees “;
    Amt := tonumber(Sum({@Amount}));
    if Amt > 10000000 then RmVal := truncate(Amt/10000000);
    if Amt = 10000000 then RmVal := 1;
    if RmVal = 1 then
    InWords := InWords + ” ” + towords(RmVal,0) + ” crore”
    else
    if RmVal > 1 then InWords := InWords + ” ” + towords(RmVal,0) + ” crores”;

    Amt := Amt – Rmval * 10000000;
    if Amt > 100000 then RmVal := truncate(Amt/100000);
    if Amt = 100000 then RmVal := 1;
    if RmVal >=1 then
    InWords := InWords + ” ” + towords(RmVal,0) + ” lakhs”;

    Amt := Amt – Rmval * 100000;
    if Amt > 0 then InWords := InWords + ” ” + towords(truncate(Amt),0);
    pAmt := (Amt – truncate(Amt)) * 100;
    if pAmt > 0 then
    InWords := InWords + ” and ” + towords(pAmt,0) + ” paisa only”
    else
    InWords := InWords + ” only”;
    UPPERCASE(InWords)
12. admin says:

    October 27, 2010 at 2:06 pm

    local stringvar isNumber := cstr({SalesOrderDetail.UnitPrice});
    local numbervar iswhole := ToNumber ({SalesOrderDetail.UnitPrice});
    local numbervar ispos := instrrev(isNumber, ‘.’);
    local numbervar isdecimal := 0;

    if ispos > 0 then
    (
    isdecimal := CDbl(right(isNumber, length(isNumber) – ispos));
    );

    Uppercase(ToWords(iswhole, 0) + ‘ Dollars and ‘ + ToWords(isdecimal, 0) + ‘ Cents Only’);