Re: Is this report format possible using straight SQL/SQL*Plus?

The answer to this is:
no, it isn't possible.

At the time sql*plus was designed, they probably didn't bother with it because RPT/RPF would do the job, and now probably reportwriter. Can't help it.

Regards,

Sybrand Bakker, Oracle DBA

"Kappy" <KapnKrunch_at_mcafeemail.com> wrote in message news:f027lsc1hu9ttp22dsfqkde0uqce19e7da_at_4ax.com...
> [NOTE: example alignment may be off due to various font widths]
>
> Column 1 Column 2 Column 3
>
> A B 10
> A B 35
> A B 25
> ------
> 70
>
>
> A C 20
> A C 10
> ------
> 30
>
>
> A D 15
>
>
> A E 35
>
>
> A F 10
> A F 20
> ------
> 30
>
>
>
>
>
>
> I have not been able to produce the above output, instead I get the
> following output using compute & breaks:
>
>
>
>
> Column 1 Column 2 Column 3
>
> A B 10
> A B 35
> A B 25
> ------
> 70
>
>
> A C 20
> A C 10
> ------
> 30
>
>
> A D 15
> ------
> 15
>
>
> A E 35
> ------
> 35
>
>
> A F 10
> A F 20
> ------
> 30
>
>
> So, Is it possible to 'not' subtotal 'every' line, but instead, only
> subtotal if there are 2 or more matches?
>
> Thanks, Kappy
Received on Fri Jun 23 2000 - 00:00:00 CEST