Data Report format

[valar2009]

Hai,

I have to format the number in data report to the followin Indian number system format i.e 23,00,000 or 1,12,00,000

Can any one help me to do for a textbox in report

Thanks in advance

[GOBI]

maybe u can check out the format() in msdn ?

[si_the_geek]

Thread moved from "Database Development" forum to "Reporting" forum

[wes4dbt]

You can use the "DataFormat" property of the text box. ie "#,###,###"

[valar2009]

You can use the "DataFormat" property of the text box. ie "#,###,###"

We can use ##,##,### for 10,00,000 but the problem is if the number is 12000 it will put ,12,000. i.e it put an extra comma before 5 digit number. so I want common format for any number of digits.

ie.

12,000
1,15,000
12,15,000
1,12,12,000

Thanks