Oracle Reports 2.5 - Sort on Sum

Hello everyone,

I am writing a break report in which I would like to order the break column by a total that is summed over the break group. The only way I can think of to do this is to somehow include the sum in the query, but that screws up the results. Any ideas?

(A graphical representation may explain better:)

Col1 Col2
---- ----

AAA      1
         8


      ----

         9  (I want to order by this value, i.e., 9>3, AAA comes first)

BBB      1
         1
         1


      ----

         3

Thanks for playing,
Christine

                                 ^