Summary in Word Format

[Rama]

Hi Everyone,

I want to display summary( Grand Total) value in word format.
Ex. if Total is 1525 then it has to display "One Thousand and Five Hundred and Twenty Five"
Can any one give the solution please......

thank you.

[almeids]

If C8 hasn't added a function for this, the only way I know of doing it is if you are on Oracle:

to_char( to_date(1525,'J'),'Jsp')

But I'm not sure of the implications of just doing it for your total, you may need a separate query.

[Palzkumar]

Does this works on SQL server also?..

[almeids]

No, it's Oracle-specific, but there may be something similar, try Googling "spell number"