Column sorting question
Here's what I got to figure out.
DataSet has these columns:
QueueID, Location, Type, Description, Date1, Date2
b0001, Delaware, Breaker, Circuit Replacement, 12/12/2007, 12/13/2007
On the grid, we have a column called "Description" that is a compound of Location, Type, Description
It makes the row look something like:
QueueID Date1 Description
b0001 12/12/2007 Location: Delaware
Desc: Circuit replacement
Note, in the above, we are not dispalying the Location column, we are building a compound description because of spacing on the page the grid is on.
Now, the powers-that-be, want it to SORT the description column on the Type value.
Is there a way to tell as specific column header to sort based on a different column? So, I'd want the Description column (3) to actually sort the grid on column (2) that isn't displayed.