locked
convert currency to word in crystal report RRS feed

  • Question

  • User-1495932509 posted
    Dear brothers, Please can anyone help me with function in crystal report that will help me convert currency to word. I will ge verry glad to see your reply on this question Thank you so much
    Friday, March 2, 2012 2:16 AM

Answers

  • User-926023460 posted

    i m giving example ,

    Ucase(left(towords({builtydetails.MrAmount}),len(towords({builtydetails.MrAmount}))-13) & " Only.")

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 2, 2012 2:18 AM
  • User-926023460 posted

    use this formula this is the indian currency converter plz chek it in urs..

    "Rs. "+ ToWords ({@calculate_TotalAmtwithChrges},0) + " and " +ToWords ((Round({@calculate_TotalAmtwithChrges},2) - Int({@calculate_TotalAmtwithChrges})) * 100, 0) + " Paise only"

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 2, 2012 2:49 AM

All replies

  • User-926023460 posted

    i m giving example ,

    Ucase(left(towords({builtydetails.MrAmount}),len(towords({builtydetails.MrAmount}))-13) & " Only.")

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 2, 2012 2:18 AM
  • User-1495932509 posted
    Sir, I am new in crystal report how can i put it as function to be used in the crystal report Thank you sir
    Friday, March 2, 2012 2:22 AM
  • User-926023460 posted

    Go to filed explorer and create new Formula filed ,

    in that edit formula paste it ..

      it sholud be work for you..

    Friday, March 2, 2012 2:24 AM
  • User-1495932509 posted
    Yes sir, I works thank you somuch i am verry greatful But how can i convert the digit behind the decimal point 100.45 the 45 as cent can i convrt it too? Thank you sir
    Friday, March 2, 2012 2:38 AM
  • User-926023460 posted

    use this formula this is the indian currency converter plz chek it in urs..

    "Rs. "+ ToWords ({@calculate_TotalAmtwithChrges},0) + " and " +ToWords ((Round({@calculate_TotalAmtwithChrges},2) - Int({@calculate_TotalAmtwithChrges})) * 100, 0) + " Paise only"

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 2, 2012 2:49 AM
  • User-926023460 posted

    hi aliyuusman4u If U get the answers of ur question then Plz and Plz mark As Answers for this person who gave the answer for your questionss,,,

    PLease....

    Friday, March 2, 2012 2:57 AM