Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Force a Sort on the Grid
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Force a Sort on the Grid
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
PurposeSoftware View Drop Down
Newbie
Newbie


Joined: 03 June 2011
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote PurposeSoftware Quote  Post ReplyReply Direct Link To This Post Topic: Force a Sort on the Grid
    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
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 04 November 2011 at 2:30pm
Hi,
 
 
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

 
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.