Member Avatar for vinayak.v

Please can anyone help me how to convert number to words in Indian format in Crystal Reports. eg. I want to convert Rs.25,12,545 as Rupees Twenty Five Lakhs Twelve thousand five hundred and fourty five only. The towords function converts into millions and billions and i want the result in Lakhs and crores. Thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 64 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mono_jit23
Member Avatar for mono_jit23 
UpperCase(ToWords ({#SummaryFeild},0))

You can try this code.... It worked for me in lower levels (for Thousands)
take a formula feild and in formula put this code.....

Note:'ToWords' is provided by crystal report .
If it doesn't work try it without the '#' symbol

Hope this helps.....:icon_idea:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.