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:
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?