Amount In Words In Crystal Report RSS

• • Reply
  

  Ashraf007

  Member

  382 Points

  1722 Posts

  Amount In Words In Crystal Report

  Feb 08, 2013 05:46 AM|LINK

  uppercase(ToWords (Sum ({command.NetValue},{command.InvoiceNo}),0) + " and cents "
  + ToWords ((Round(Sum ({command.NetValue}, {command.InvoiceNo}),2)
  - Int(Sum ({command.NetValue}, {command.InvoiceNo}))) * 100, 0) + " Only")

  The above is my code, its working fine. but the value is getting double due to sum of in the field. I need to remove the sum of in the above formula.

  Thanks In Advance ....
  • Edited by Ashraf007 on Feb 08, 2013 05:46 AM
• • Reply
  

  Ashraf007

  Member

  382 Points

  1722 Posts

  Re: Amount In Words In Crystal Report

  Feb 08, 2013 06:17 AM|LINK

  I need to remove only the sum of in the above forumla 

  Thanks In Advance ....
• • Reply
  

  matifnadeem

  Contributor

  4580 Points

  1090 Posts

  Re: Amount In Words In Crystal Report

  Feb 08, 2013 09:38 AM|LINK

  Hi Ashraf007,

  To display total amount in words in crystal reports, check these links

  http://stackoverflow.com/questions/4698280/number-to-words-crystal-report
  
  http://scn.sap.com/thread/1297108

  Cheers

  
  M Atif Nadeem
  Mark as Answer if you got right thing
  Read my blog | Follow me on LinkedIn
• • Reply
  

  Ashraf007

  Member

  382 Points

  1722 Posts

  Re: Amount In Words In Crystal Report

  Feb 08, 2013 04:29 PM|LINK

  I got the solution, its working fine. Thanx

  
  

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

  Thanks In Advance ....
  • Marked as answer by Ashraf007 on Feb 08, 2013 04:29 PM