I want to convert numeric value to word (ex: 100 ----> Hundred) in SSRS2005.this is available in crystal reports. If anybody know plz reply. Regards, Hasitha

Hi,

As far as I know, there is no built-in facility to covert the number into words unless you write your own codes. This link may help you to write your own code.

Thank you for help. But  it is bit confusing. In SSRS2005 where we can write C# code.

 

regards,

Hasitha

Check this,

http://bloggingabout.net/blogs/mglaser/archive/2006/10/25/Using-custom-.NET-code-with-Reporting-Services-part-I.aspx

 

---

Blog: http://dineshasanka.spaces.live.com

Hi Hasitha,

Hope Dinesh Asanka's post solves your problem. If you still face for problems, let us know, we will make a sample and attach.

Hi Dinesh,
Thankx .once again. I tried hard, I don’t know why I can’t access functions (we can only use Vb.net as I know) define in the embedded code. If you don’t mind tell me what the problem is. I try to call function in a textbox.

Regards,
Hasitha

Hiiii,

It is working. Sorry 4 bother you. In expression editor it displayed as unrecognized identifier, it makes me confuse. But it is working. thankx for all.

Great . The editor does not give any formatting or shows keywords with different colors.

Anyway, the posts you make does not bother us, please do not hesitate to ask anything unclear, related to SQL Server.

great! I have posted a entry in my blog for any other poeple who will required this in future

---

Blog: http://dineshasanka.spaces.live.com