Is there a way, without using a SQL Server view, to sort the source resultset on columns A, B and C while collapsing on A? Here is what I want:
SQL Server | -> | Notes |
ListNumber (asc) | Collapse | ListNumber |
LastName (asc) | LastName | |
FirstName (asc) | FirstName |
Right now I'm doing this by using a SQL Server view that sorts on these three columns. I would like to do without that view. Is this possible while still using CollExp?

