Is this report format possible using straight SQL/SQL*Plus?
From: Kappy <KapnKrunch_at_mcafeemail.com>
Date: 2000/06/23
Message-ID: <f027lsc1hu9ttp22dsfqkde0uqce19e7da_at_4ax.com>#1/1
Date: 2000/06/23
Message-ID: <f027lsc1hu9ttp22dsfqkde0uqce19e7da_at_4ax.com>#1/1
[Quoted] [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