Report Control - Which Column is being Sorted By ?

Print Page | Close Window

Which Column is being Sorted By ?

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=3588
Printed Date: 30 April 2025 at 9:51am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Which Column is being Sorted By ?

Posted By: LeeHayton
Subject: Which Column is being Sorted By ?
Date Posted: 02 February 2006 at 10:31am

In Outlook the rows are grouped by the Column Header that is clicked I want to recreate the same functionality.

How can I determine which column has been clicked - the control (v9.61) only triggeres as the column header is "Right Clicked" - which is really no good.

So - within the wndReportControl_SortOrderChanged Sub I would like to determine which column is the sorted column and then use that as the groupable column.

e.g. WndReportControl.GroupsOrder.Add TheColumnWeWant

TIA

Lee

Replies:

Posted By: SuperMario
Date Posted: 03 February 2006 at 12:19pm

Take a look at this:

Private Sub wndReportControl_SortOrderChanged()
Debug.Print wndReportControl.SortOrder.Column(wndReportControl.SortOrder .Count - 1).Caption & " was just sorted"
End Sub