Re: Oracle Reports 2.5 - Sort on Sum

Krustina wrote:
>
> 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
>
> ****************************************************************************
> Birth... School... Work... Death...
> ^
>

Hi,

I am not sure if it will be good, but try this:

create master-datail report
master query: select col1,sum(col2) from ... order by 2   and disable group for this query in default layout detail query: select col1,col2 from ...

                Peter. Received on Wed Jul 31 1996 - 00:00:00 CEST