convert Number into word

Hi BIRT Guru

Meany thanks for response.
I am taking help of javascript for this issue.I am very close to solve this.Once get solved i will share that on this post.

I still have one more open discussion regarding merging reports with proper paging order.
I am not able to find any solution for that.
If you can see please provide me solution for that.

Regards,
Santosh

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76884" data-time="1305129426" data-date="11 May 2011 - 08:57 AM"><p>
If you create a javascript function to do this, it would be a good addition to the <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/'>devShare</a><br /></p></blockquote>
<br />
<br />
Here is the required javascript to do this...<br />
<br />
var th = ['','thousand','million', 'billion','trillion'];<br />
var dg = ['zero','one','two','three','four', 'five','six','seven','eight','nine']; var tn = ['ten','eleven','twelve','thirteen', 'fourteen','fifteen','sixteen', 'seventeen','eighteen','nineteen']; var tw = ['twenty','thirty','forty','fifty', 'sixty','seventy','eighty','ninety']; function toWords(s){s = s.toString(); s = s.replace(/[\, ]/g,''); if (s != parseFloat(s)) return 'not a number'; var x = s.indexOf('.'); if (x == -1) x = s.length; if (x > 15) return 'too big'; var n = s.split(''); var str = ''; var sk = 0; for (var i=0; i < x; i++) {if ((x-i)%3==2) {if (n == '1') {str += tn[Number(n[i+1])] + ' '; i++; sk=1;} else if (n!=0) {str += tw[n-2] + ' ';sk=1;}} else if (n!=0) {str += dg[n] +' '; if ((x-i)%3==0) str += 'hundred ';sk=1;} if ((x-i)%3==1) {if (sk) str += th[(x-i-1)/3] + ' ';sk=0;}} if (x != s.length) {var y = s.length; str += 'point '; for (var i=x+1; i<y; i++) str += dg[n] +' ';} return str.replace(/\s+/g,' ');}<br />
<br />
<br />
just pass your data column as argument.<br />
<br />
<br />
Regards,<br />
Santosh....

<blockquote class='ipsBlockquote' data-author="'johnw'" data-cid="76968" data-time="1305238515" data-date="12 May 2011 - 03:15 PM"><p>
Michael,<br />
<br />
Would it be helpful if I created a Function extension to do this and add it to the Marketplace? This is not the first time this request has come up, and I've had it on my ToDo list for a while to write a post about it. wondering if it wouldn't just be better to do an extension.<br />
<br />
John<br /></p></blockquote>
<br />
Hi Michael,<br />
<br />
Please let me Know if there is any error that might be possible with this script.<br />
To use this script pass your Decimal dataSet to this function [toWords(s)].<br />
<br />
Regards<br />
<br />
Santosh..