PDA

Click to See Complete Forum and Search --> : Data Report format


valar2009
Jul 3rd, 2009, 04:25 AM
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
Jul 3rd, 2009, 09:38 AM
maybe u can check out the format() in msdn ?

si_the_geek
Jul 5th, 2009, 10:58 AM
Thread moved from "Database Development" forum to "Reporting" forum

wes4dbt
Jul 5th, 2009, 11:26 AM
You can use the "DataFormat" property of the text box. ie "#,###,###"

valar2009
Jul 8th, 2009, 04:33 AM
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