Codejock Developer Community : Sorting dates

Codejock Developer Community : Sorting dates http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 00:49:20 +0000 Tue, 21 Sep 2010 08:35:05 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=17215 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sorting dates : Thanks for your interest Aaron....]]> http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60369&title=sorting-dates#60369 Author: CapoPezzio
Subject: 17215
Posted: 21 September 2010 at 8:35am

Thanks for your interest Aaron. But I think I found my problem. There were some old code wich "converted" my sql, my date-columns where converted in the sql-statement... select col1,col2 ,convert(varchar(24),col3,104) from....

..wich resultet in my recordset(and ReportControl) treated my date-column as text, and therefore sorted it as text.
Removed the old code in the sql-statement and did the formating in RC_BeforeDrawRow. It did wonder.

Private Sub RC_BeforeDrawRow(ByVal Row As XtremeReportControl.IReportRow, ByVal item As XtremeReportControl.IReportRecordItem, ByVal Metrics As XtremeReportControl.IReportRecordItemMetrics)
   if item.index = index_of_datecol
      item.format = "%d.%m.%Y"
      Metrics.Text = item.Caption
    end if

End Sub

did this because my date-columns contains date and time and I only wanted to show date
]]> Tue, 21 Sep 2010 08:35:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60369&title=sorting-dates#60369 <![CDATA[Sorting dates : Hi, I tried with CJ sample...]]> http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60349&title=sorting-dates#60349 Author: Aaron
Subject: 17215
Posted: 21 September 2010 at 5:57am

Hi,

I tried with CJ sample and it actually sorts date/time values...

Can you upload small test project?

Thanks

]]> Tue, 21 Sep 2010 05:57:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60349&title=sorting-dates#60349 <![CDATA[Sorting dates : Hi. I dont find a way to set the...]]> http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60347&title=sorting-dates#60347 Author: CapoPezzio
Subject: 17215
Posted: 21 September 2010 at 5:20am

Hi. I dont find a way to set the types of my columns when I use Databind. Anyone know if there is a way to set the type (ie Date) on all the data in a Column when I use Databind, so my sorting will work. Now I have to go through every dateitems in every rows and set the format manually. I have 3 date-columns and when I have 200000 records in my grid it takes 10 seconds(wich in my world is ages Smile

), just to set the dates right so the sorting will work.]]> Tue, 21 Sep 2010 05:20:34 +0000 http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60347&title=sorting-dates#60347 <![CDATA[Sorting dates : Hi, If I add an item as Date...]]> http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60162&title=sorting-dates#60162 Author: Aaron
Subject: 17215
Posted: 13 September 2010 at 9:59am

Hi,

If I add an item as Date it will sorted as date so (don't know for sure...) I don't think DataBind feature supports types yet ????

]]> Mon, 13 Sep 2010 09:59:25 +0000 http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60162&title=sorting-dates#60162 <![CDATA[Sorting dates : I am using Reportcontrol and give...]]> http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60080&title=sorting-dates#60080 Author: CapoPezzio
Subject: 17215
Posted: 07 September 2010 at 7:30am

I am using Reportcontrol and give it a recordset and uses databind.

My database have dateformat dd.mm.yyyy and I want to show it that way. That works fine, but when I sort on a date-column it is not correct.

it shows

01.01.2007
01.01.2008
02.01.2007
02.03.2008
02.04.2007

My workaround at the moment is afters Databind I go through every dateitem in the Reportcontrol and set the caption-property to show dd.mm.yyyy format an set the value-property to yyyymmdd-format. This way it shows correct and it sorts correct. But I thought this was going to work with no workaround. Any idea?

]]> Tue, 07 Sep 2010 07:30:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=17215&PID=60080&title=sorting-dates#60080