Codejock Developer Community : Sort Not Working http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 04:27:54 +0000 Wed, 30 Jun 2010 05:28:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=16777 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sort Not Working : I have same problem. Edit: solved. At...]]> http://forum.codejock.com/forum_posts.asp?TID=16777&PID=59163&title=sort-not-working#59163 Author: Jacob2
Subject: 16777
Posted: 30 June 2010 at 5:28am

I have same problem.

Edit: solved.

At first i used the caption property to assign text to the 'cells'. Now i'm using the value property instead and it's sorting fine.

]]> Wed, 30 Jun 2010 05:28:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=16777&PID=59163&title=sort-not-working#59163 <![CDATA[Sort Not Working : Hi, Can you upload a small...]]> http://forum.codejock.com/forum_posts.asp?TID=16777&PID=58792&title=sort-not-working#58792 Author: Aaron
Subject: 16777
Posted: 04 June 2010 at 11:56am

Hi,
 
Can you upload a small test project? So I'm able to reproduce your problem?
 
Thanks
 
]]> Fri, 04 Jun 2010 11:56:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=16777&PID=58792&title=sort-not-working#58792 <![CDATA[Sort Not Working : My init code: With rc1 .Records.DeleteAll...]]> http://forum.codejock.com/forum_posts.asp?TID=16777&PID=58752&title=sort-not-working#58752 Author: faithless
Subject: 16777
Posted: 01 June 2010 at 2:44am

My init code:

                With rc1
                    .Records.DeleteAll
                    .Columns.DeleteAll
                    .Populate
                    .PreviewMode = True
                    .AutoColumnSizing = True
                    .AllowColumnSort = True
                    Set Col = AddColumn(rc1, "", 30, False, False)
                    Set Col = AddColumn(rc1, "", 30, False, False)
                    Set Col = AddColumn(rc1, "COL1", 70, False, False)
                    Col.Alignment = xtpAlignmentCenter
                    Set Col = AddColumn(rc1, "COL2", 100, False, False)
                    Set Col = AddColumn(rc1, "COL3", 125, False, False)
                    Set Col = AddColumn(rc1, "COL4", 250, True, True)
                    Set Col = AddColumn(rc1, "COL5", 300, True, True)
                    Set Col = AddColumn(rc1, "COL6", 50, False, False)
                    Col.Visible = False
                End With
For lCol = 0 To rc1.Columns.Count - 1
      rc1.Columns(lCol).Sortable = True
Next

Private Function AddColumn(ByRef p_ReportControl As ReportControl, ByVal p_Caption As String, ByVal p_MinimumWidthPx As Long, ByVal p_Resizable As Boolean, ByVal p_AutoSize As Boolean, Optional p_Sortable As Boolean = True) As ReportColumn
   ' This is a generic function for adding columns to the ReportControl
   ' It bases the starting column width on the passed miminum column width as suggested by Mark Doubson @ Codejock
   ' See http://forum.codejock.com/forum_posts.asp?TID=13379&PID=48715#48715
   ' It also ensures that the column ItemIndex is correct by basing it on the column count at the time the column is added
  
   With p_ReportControl
      Set AddColumn = .Columns.Add(.Columns.Count, p_Caption, p_MinimumWidthPx - 10, p_Resizable)
      With AddColumn
         .AutoSize = p_AutoSize
         .MinimumWidth = p_MinimumWidthPx
         .Sortable = p_Sortable
      End With
   End With
End Function


After populate of the control clicking colums headers not sort records, it shows only small arrow down or up.
]]> Tue, 01 Jun 2010 02:44:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=16777&PID=58752&title=sort-not-working#58752