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

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: 2000/08/06
Message-ID: <8miv5b$6dsml$1@ID-41926.news.cis.dfn.de>#1/1

Kappy,

I am studying how to create reports using SQL*Plus, can you show me your script about using compute and breaks to create subtotals? Thanks in advance. You can reply to news or via e-mail to me.

Dino
Kappy <KapnKrunch_at_mcafeemail.com> wrote in message news:dfh5ls4b1fakl1mfkn91caj72fbhjn5021_at_4ax.com...
> [BOTE: 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 Sun Aug 06 2000 - 00:00:00 CDT