|
Column Number Format |
Post Reply 
|
| Author | |
SHAN 
Groupie 
Joined: 17 July 2010 Location: Dubai Status: Offline Points: 73 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Column Number FormatPosted: 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 |
|
 |
|
|
Aaron
Senior Member 
Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
Quote Reply
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.
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.... |
|
|
|
|
SHAN
Groupie
Joined: 17 July 2010 Location: Dubai Status: Offline Points: 73 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
JamGodz
Groupie
Joined: 25 February 2010 Status: Offline Points: 67 |
Post Options
Thanks(0)
Quote Reply
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... |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options