Sorting by Summary columns -Reports Builder 6

DEP      EMP       SAL
---      ---      -----
ELK       A        250
          B        100


                   ---

                   350

MEK       E         45  
          F         20


                   ---

                    65

PER       C         90 
          D         50


                   ---

                   140

Reports builder sorts these fields by group field (DEP) My problem is to sort these summary fields in descending order. (350, 140, 65) Is there a way to do this in report builder 6.

DEP      EMP       SAL
---      ---      -----
ELK       A        250
          B        100


                   ---

                   350

PER       C         90 
          D         50


                   ---

                   140

MEK       E         45  
          F         20


                   ---

                    65

Thanks in advance. Received on Tue Feb 18 2003 - 09:49:32 CET