InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:40:27 GMT20http://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxVinay,Hope the below url will help you[url]http://www.demtron.com/blog/post/2009/02/02/VBNet-Converting-Number-to-Words.aspx[/url]Use this in custom codeTue, 16 Nov 2010 06:16:40 GMTArunkumar S Phttp://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxhi steveb...one more doubt...please tell me how to print the number in words...i.e crores,lakhs, thousands... etc...please help meTue, 16 Nov 2010 04:52:14 GMTvinayak.vhttp://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxthanku... stevb... i got it.......thanks...:-):-):-):-)Tue, 16 Nov 2010 04:42:03 GMTvinayak.vhttp://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxhow do you know that?i am using 2008r2Tue, 16 Nov 2010 04:37:14 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxbut... the steps belongs to ssrs2005..i'm working with ssrs2008... Tue, 16 Nov 2010 04:33:21 GMTvinayak.vhttp://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxyou don't really need to 'write' it anywhere.steps would be1. delete your existing format expression2. click on your report in design mode3. press F4 to bring up report properties4. Under language change to hi-IN5. right-click on your textbox6. click text-box properties7. click number 8. under category select number9. check the box labeled 'use regional formatting'10. preview reportTue, 16 Nov 2010 04:13:33 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxthanku...but where to write .. this... please send me the steps...Tue, 16 Nov 2010 04:08:48 GMTvinayak.vhttp://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxI assume that you are trying to put the numbers into the Indian number format of ##,##,###.##Rather than create your own custom format for this you can change the language of the report to hi-IN (or one of the other Indian languages), and then in the text-box properties, under number change the format to number and click on 'use regional formatting' and this will display your numbers using the indian format.Tue, 16 Nov 2010 04:04:32 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic1021335-150-1.aspxhi... to all..i've written the code in expression field...=format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00")the code is for printing the number in this format(12,23,23,34,123.00)now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. how the word length is there that much it should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...i've tried by removing some of the #'s but it is for fixed number.. please help me...Tue, 16 Nov 2010 03:37:14 GMTvinayak.v