Column Number Format
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=17294
Printed Date: 15 November 2024 at 3:18pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Column Number Format
Posted By: SHAN
Subject: Column Number Format
Date 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....!
------------- Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows 7 Professional Language: Visual Basic 6.0 |
Replies:
Posted By: Aaron
Date 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.
http://forum.codejock.com/uploads/3701/20090608_144218_MoneyFormat1.zip - uploads/3701/20090608_144218_MoneyFormat1.zip
Good luck
 ------------- Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
Posted By: SHAN
Date 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 ------------- Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows 7 Professional Language: Visual Basic 6.0 |
Posted By: JamGodz
Date 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... |