1 Reply Latest reply: Nov 21, 2012 9:07 AM by SimonHoy RSS

    Convert / Cast Number to Words in reports

    879762
      I need some help in reporting. I have a report that has some number & currency fields. The customer wants those numbers written out in words.
      For e.g. $1000 - $ One Thousand
      or 999 - Nine Hundred Ninety nine
      etc.

      Using CAST it only convert the number to string not actual words.
      Is there any way to write it out in words in reports?

      Thanks in advance
        • 1. Re: Convert / Cast Number to Words in reports
          SimonHoy
          Gaurav wrote:
          I need some help in reporting. I have a report that has some number & currency fields. The customer wants those numbers written out in words.
          For e.g. $1000 - $ One Thousand
          or 999 - Nine Hundred Ninety nine
          etc.

          Using CAST it only convert the number to string not actual words.
          Is there any way to write it out in words in reports?

          Thanks in advance
          Hello,

          CAST only changes the data type e.g. Integer to String as you rightly pointed out, there are no out of the box functions that would allow you convert them to the format you require.