Sorting a Crosstab Report

[John]

Is there a way to sort the columns of a crosstab report?

I've tried sorting the stored procedure and tried adding a Sorting expression to the crosstab control but neither seem to work.

[Steve]

Hello John,

Column/Row concepts are abstract when it comes to crosstab, which works with Column/Row Group hierarchies. The sorting occurs to the members of a group, so if for example you have two groups Countries and Cities, if you want to sort by Cities, you would have to choose the Cities group properties and apply sorting accordingly.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[John]

Thanks.  Didn't see that you could right click on group column to change settings.

worked great.