Codejock Developer Community : Report Control Sorting dates....

Report Control Sorting dates.... : The ReportControl is now smart...

Wed, 23 Feb 2005 13:15:33 +0000

Author: SuperMario
Subject: 1097
Posted: 23 February 2005 at 1:15pm

The ReportControl is now smart enought to sort by date with no work arounds.

Report Control Sorting dates.... : Another solution, which Maui found...

Thu, 02 Sep 2004 10:14:04 +0000

Author: ianp
Subject: 1097
Posted: 02 September 2004 at 10:14am

Another solution, which Maui found (see https://forum.codejock.com/forum_posts.asp?TID=1119& PN=1#2921) is to set the Value to the date/number, then set the caption to the formatted value, which leaves the sortpriority free to be used as intended.

e.g.

Item.Value = val
If IsDate(Item.Value)
    Item.Caption = Format(val, "ddd dd/mm/yyyy")
ElseIf IsNumeric(Item.Value)
    Item.Caption = Format(val, "#,##0.00")
Else
    Item.Caption = Item.Value
End if

Edited by ianp

Report Control Sorting dates.... : One solution I've found is...

Sun, 22 Aug 2004 04:39:26 +0000

Author: ianp
Subject: 1097
Posted: 22 August 2004 at 4:39am

One solution I've found is to populate the SortPriority with the numeric value of the date e.g.

If IsDate(val)
    Item.Value = Format(val, "ddd dd/mm/yyyy")
    Item.SortPriority = val
Else
    Item.Value = val
End if

However, since the SortPriority is a Long, this method doesn't cater for the time portion of a date/time value!

Report Control Sorting dates.... : I have studing you reportcontrol...

Sat, 21 Aug 2004 11:19:31 +0000

Author: Jens4
Subject: 1097
Posted: 21 August 2004 at 11:19am

I have studing you reportcontrol sample, but cant figure out how the control trying to sort the dates columns .... maybe it is because my windows use the date format dd-mm-yyyy (danish), that sample just does't sort the dates columns in a right way....

anybody have a small small samples that can sort a date column correctly.... (is has to work with at data and a time)

Kind regards

Jens