correct the expression of the textbox field

Question

correct the expression of the textbox field

vinayak.v

SSCrazy

Points: 2414
More actions
November 16, 2010 at 3:37 am

#388238

hi... 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...

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

I 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.

vinayak.v SSCrazy Points: 2414 More actions · Answer 2

thanku...

but where to write .. this... please send me the steps...

steveb. SSC-Forever Points: 46733 More actions · Answer 3

you don't really need to 'write' it anywhere.

steps would be

1. delete your existing format expression

2. click on your report in design mode

3. press F4 to bring up report properties

4. Under language change to hi-IN

5. right-click on your textbox

6. click text-box properties

7. click number

8. under category select number

9. check the box labeled 'use regional formatting'

10. preview report

vinayak.v SSCrazy Points: 2414 More actions · Answer 4

but... the steps belongs to ssrs2005..

i'm working with ssrs2008...

steveb. SSC-Forever Points: 46733 More actions · Answer 5

steveb.

SSC-Forever

Points: 46733

November 16, 2010 at 4:37 am

#1251221

how do you know that?

i am using 2008r2

vinayak.v SSCrazy Points: 2414 More actions · Answer 6

thanku... stevb...

i got it.......

thanks...:-):-):-):-)

vinayak.v SSCrazy Points: 2414 More actions · Answer 7

hi steveb...

one more doubt...

please tell me how to print the number in words...

i.e crores,lakhs, thousands... etc...

please help me

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 8

Vinay,

Hope the below url will help you

http://www.demtron.com/blog/post/2009/02/02/VBNet-Converting-Number-to-Words.aspx

Use this in custom code

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P