Sorting a Crostab - by grand total?

[jstasz]

I am creating a crosstab summarizing the total tonnes rejected, by reject code. There are a couple of other columns in the crosstab, for exposed and unexposed etc.

The report needs to be sorted in descending order by the grand total column. (total tonnes per reject code)

I cannot find a way to sort so I am leaning toward creating a manual crosstab. Is this my best option?

 

[IdoMillet]

Select the CrossTab (click top left corner).

Use Report, TopN/Sort Group Expert to sort the CrossTab
(not very intuitive, I know).

You must use a TopN so simply select N large enough that your CrossTab will never exceed it.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Wallie12]

Or you could do you summing in a SQL statement or Stored Procedure and sort it prior to entering CRYSTAL.

Wallie12