Print Page | Close Window

Multi level sorting

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=9418
Printed Date: 20 September 2024 at 6:48am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: Multi level sorting
Posted By: sunbeam
Subject: Multi level sorting
Date Posted: 27 January 2008 at 6:38am
Hi,
 
Is it possible in the ReportControl to sort on one column, than sort on another column within that column, than sort on another column within that second column etc... without grouping them together?
 
Thanks in advance



Replies:
Posted By: wlcabral
Date Posted: 27 January 2008 at 12:19pm

Codejock's help :


Example
[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

 

Example
[Visual Basic] This sample illustrates how to remove all columns from the ReportControl's collection of SortOrder and GroupOrder columns.


    'Removes all columns from the ReportControl's GroupsOrder collection
    wndReportControl.GroupsOrder.DeleteAll

    'Removes all columns from the ReportControl's SortOrder collection
    wndReportControl.SortOrder.DeleteAll



-------------
wlcabral



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net