Codejock Developer Community : Sort the column to numeric values​​? http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 23:36:10 +0000 Thu, 14 Jul 2011 09:52:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=18655 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sort the column to numeric values​​? : Aaron wrote:...Private Sub...]]> http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65271&title=sort-the-column-to-numeric-values#65271 Author: g.novi
Subject: 18655
Posted: 14 July 2011 at 9:52am

Originally posted by Aaron Aaron wrote:

...

Private Sub wndReportControl_BeforeDrawRow(ByVal Row As XtremeReportControl.IReportRow, ByVal Item As XtremeReportControl.IReportRecordItem, ByVal Metrics As XtremeReportControl.IReportRecordItemMetrics)

    Row.Record.Item(0).Caption = Format(Row.Record.Item(0).Value, "##0.#0")

End Sub


Very well !!!

Thank you

]]> Thu, 14 Jul 2011 09:52:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65271&title=sort-the-column-to-numeric-values#65271 <![CDATA[Sort the column to numeric values​​? : g.novi wrote: If I convert...]]> http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65255&title=sort-the-column-to-numeric-values#65255 Author: Aaron
Subject: 18655
Posted: 13 July 2011 at 4:41pm

Originally posted by g.novi g.novi wrote:

[...]
If I convert text into Double type it works, but the number will not be formatted!
How can I do!?
[...]

OK, you solved that part...

You can't use .Format property because it will be "converted" to a string and it doesn't sort properly anymore. Best way is to use custom format in BeforeDrawRow event something like this:

in FormLoad (or wherever you initialize RC) set:
wndReportControl.SetCustomDraw xtpCustomBeforeDrawRow

 
Private Sub wndReportControl_BeforeDrawRow(ByVal Row As XtremeReportControl.IReportRow, ByVal Item As XtremeReportControl.IReportRecordItem, ByVal Metrics As XtremeReportControl.IReportRecordItemMetrics)
 
    Row.Record.Item(0).Caption = Format(Row.Record.Item(0).Value, "##0.#0")

End Sub

Hope this helps Wink
 
 
]]> Wed, 13 Jul 2011 16:41:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65255&title=sort-the-column-to-numeric-values#65255 <![CDATA[Sort the column to numeric values​​? : Aaron wrote:... If you are...]]> http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65252&title=sort-the-column-to-numeric-values#65252 Author: g.novi
Subject: 18655
Posted: 13 July 2011 at 10:52am

Originally posted by Aaron Aaron wrote:

...
If you are able to convert text to type you need it will work, if you can't just set .SortPriority when adding items to RC  

If I convert text into Double type it works, but the number will not be formatted!
How can I do!?

Thank's
]]> Wed, 13 Jul 2011 10:52:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65252&title=sort-the-column-to-numeric-values#65252 <![CDATA[Sort the column to numeric values​​? : Aaron wrote:Hi, Did add...]]> http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65250&title=sort-the-column-to-numeric-values#65250 Author: g.novi
Subject: 18655
Posted: 13 July 2011 at 10:21am

Originally posted by Aaron Aaron wrote:

Hi,
Did add numeric values as text or as Integer, Long, Double? RC supports type sorting. If you added it as text it sorts like MS explorer does,   1,10,11,2,3,4,5 etc, etc
 
If you are able to convert text to type you need it will work, if you can't just set .SortPriority when adding items to RC  

Hi,
maybe because I insert formatted numbers? (Ex: 12 in 12,00).
How do I get formatted numbers and correct sort?
Thank You.

]]> Wed, 13 Jul 2011 10:21:41 +0000 http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65250&title=sort-the-column-to-numeric-values#65250 <![CDATA[Sort the column to numeric values​​? : Hi, Did add numeric values...]]> http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65247&title=sort-the-column-to-numeric-values#65247 Author: Aaron
Subject: 18655
Posted: 13 July 2011 at 8:13am

Hi,
 
Did add numeric values as text or as Integer, Long, Double? RC supports type sorting. If you added it as text it sorts like MS explorer does,   1,10,11,2,3,4,5 etc, etc
 
If you are able to convert text to type you need it will work, if you can't just set .SortPriority when adding items to RC  
 
 
]]> Wed, 13 Jul 2011 08:13:27 +0000 http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65247&title=sort-the-column-to-numeric-values#65247 <![CDATA[Sort the column to numeric values​​? : How to sortthe column tonumeric...]]> http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65246&title=sort-the-column-to-numeric-values#65246 Author: g.novi
Subject: 18655
Posted: 13 July 2011 at 7:27am

How to sort the column to numeric values​​?
A report column contains numeric values ​​but the sort does not work.

Now sort in this way:
   10,00
 100,00
   12,00
   13,00   
   20,00
     3,00
 
I would like this result:
     3,00
   10,00
   12,00
   13,00   
   20,00
 100,00

Thank's to all
   
]]> Wed, 13 Jul 2011 07:27:41 +0000 http://forum.codejock.com/forum_posts.asp?TID=18655&PID=65246&title=sort-the-column-to-numeric-values#65246