Codejock Developer Community : Force a Sort on the Grid http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 19:57:15 +0000 Fri, 04 Nov 2011 14:30:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=18979 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Force a Sort on the Grid : Hi, Seems you have same problem...]]> http://forum.codejock.com/forum_posts.asp?TID=18979&PID=66735&title=force-a-sort-on-the-grid#66735 Author: Aaron
Subject: 18979
Posted: 04 November 2011 at 2:30pm

Hi,
 
Seems you have same problem as: http://forum.codejock.com/forum_posts.asp?TID=19020&title=new-row-does-not-sort-properly
 
If a column is sorted (ASC or DESC) and after call .Populate the grid is sorted again. Can you upload some kind of test project which shows your problem?
 
Sort columns by code: use SortOrder collection. Here's Sample from CJ (see Help)
 

Example

[Sorting columns in the ReportControl (Visual Basic)] This sample illustrates how to sort the columns in the ReportControl. If you had 8 columns added to the ReportControl, this sample would sort the columns first by the column at Itemindex 7, then by the column at ItemIndex 2, then by the column at ItemIndex 5.

    'This code below will add three columns to the SortOrder collection of coluns.
    'This will cause the columns in the ReportControl to first be sorted by column 7,
    'which has an index of zero (0) in the SortOrder collection. Columns are first sorted
    'in the order that they are added to the SortOrder collection.
    wndReportControl.SortOrder.Add wndReportControl.Columns(7)
    wndReportControl.SortOrder.Add wndReportControl.Columns(2)
    wndReportControl.SortOrder.Add wndReportControl.Columns(5)

    'This will cause the column at index 1 of the SortOrder collection to be sorted
    'in descending order.
    wndReportControl.SortOrder(1).SortAscending = False

    'Any time you add or delete columns to the SortOrder or GroupOrder collections,
    'the Populate method must be called to show the changes in the ReportControl's view.
    wndReportControl.Populate

See Also

ReportColumnOrder Collection  | ReportControl SortOrder Property  | ReportControl GroupsOrder Property

Example

GroupsOrder Sample

 
]]> Fri, 04 Nov 2011 14:30:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=18979&PID=66735&title=force-a-sort-on-the-grid#66735 <![CDATA[Force a Sort on the Grid : I add a record to the grid, do...]]> http://forum.codejock.com/forum_posts.asp?TID=18979&PID=66397&title=force-a-sort-on-the-grid#66397 Author: PurposeSoftware
Subject: 18979
Posted: 23 September 2011 at 7:36am

I add a record to the grid, do a Populate but the new item isn't inserted into the correct position.

If I click the column header twice to sort (1st time to sort the wrong way then the 2nd to sort the right way) it will sort correctly.

So, how do I force a Sort of the grid.

Ie. wndReport.Sort

Colin
PurposeSoftware

]]> Fri, 23 Sep 2011 07:36:06 +0000 http://forum.codejock.com/forum_posts.asp?TID=18979&PID=66397&title=force-a-sort-on-the-grid#66397