Codejock Developer Community : Column Number Format http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 00:49:03 +0000 Wed, 22 Sep 2010 07:38:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=17294 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Column Number Format : Hi Shan,Nice! but have you tried...]]> http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60405&title=column-number-format#60405 Author: JamGodz
Subject: 17294
Posted: 22 September 2010 at 7:38am

Hi Shan,

Nice! but have you tried to use the groupformula and sum up the item(the you have formatted with comma)?. as i have tested it wont sum up...

is this a limitation in RC? hope is not..

thanks...
]]> Wed, 22 Sep 2010 07:38:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60405&title=column-number-format#60405 <![CDATA[Column Number Format : Hi Aaron , Thanks for your...]]> http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60399&title=column-number-format#60399 Author: SHAN
Subject: 17294
Posted: 22 September 2010 at 4:18am

Hi Aaron ,
 
 Thanks for your Quick reply ...!
 
 
I tried and found myself a solution for this issue.....!
 
 
Private Sub ReportControl1_BeforeDrawRow(ByVal Row As XtremeReportControl.IReportRow, ByVal Item As XtremeReportControl.IReportRecordItem, ByVal Metrics As XtremeReportControl.IReportRecordItemMetrics)
 
    Row.Record.Item(3).Caption = Format(Row.Record.Item(3).Caption, "##,##0")

End Sub
]]> Wed, 22 Sep 2010 04:18:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60399&title=column-number-format#60399 <![CDATA[Column Number Format : Hi, I know format property...]]> http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60396&title=column-number-format#60396 Author: Aaron
Subject: 17294
Posted: 22 September 2010 at 3:46am

Hi,
 
I know format property isn't wonderfull for non US users... I did test once and couldn't solve this but with the help of Jason (@jpbro) I solved the formatting issue. Maybe it can help you too.
 
uploads/3701/20090608_144218_MoneyFormat1.zip
 
Good luck Wink
 
]]> Wed, 22 Sep 2010 03:46:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60396&title=column-number-format#60396 <![CDATA[Column Number Format : Hi, I want to set a Column...]]> http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60388&title=column-number-format#60388 Author: SHAN
Subject: 17294
Posted: 22 September 2010 at 1:34am

Hi,
 
 I want to set a Column Number Format.
 
 Currently it shows like this:   12345
 
 I need to show the format like this: 12,345 (Comma Format)
 
 
How to do this? Anyone pls help....!
 
 
]]> Wed, 22 Sep 2010 01:34:17 +0000 http://forum.codejock.com/forum_posts.asp?TID=17294&PID=60388&title=column-number-format#60388