Print Page - Summary in Word Format

Title: Summary in Word Format
Post by: Rama on 03 Apr 2008 05:10:19 AM

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.

Title: Re: Summary in Word Format
Post by: almeids on 03 Apr 2008 08:33:01 AM

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.

Title: Re: Summary in Word Format
Post by: Palzkumar on 07 Apr 2008 04:33:23 AM

Does this works on SQL server also?..

Title: Re: Summary in Word Format
Post by: almeids on 07 Apr 2008 08:12:44 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Rama on 03 Apr 2008 05:10:19 AM