Crystal Reports – How to order cross tab by total column (sort largest to smallest)

The following steps show how to order a cross tab in Crystal Reports from largest to smallest – by default the order would be by first column alphabetically.

For example:

This ensures that the largest value in the selected column appears at the top.

 

1. After creating your cross tab, right-click on it and choose ‘Group Sort Expert’
2. 
3. Under ‘For this group sort’ choose ‘All’
   
4. Under ‘based on’ choose the column you want to sort by
5. Then choose ‘Descending’ for the order
6. 
7. Click OK to save the changes.
8. The cross tab will now be sorted from largest to smallest.
9. 

Reference: http://stackoverflow.com/questions/1428184/cross-tab-report-how-to-control-row-order