Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql plus question
If you do it the second way you don't need Excel
just
break on report
compute sum of type1 on report
compute sum of type2 on report
etc.
OTOH (not that I want to say any negative about Sql*plus) why don't you just use ODBC, and handle the query and sums by connecting excel via ODBC to your database?
Hth,
--
Sybrand Bakker, Oracle DBA
Joe D <joed_at_icoms.com> wrote in message news:38345fbe_at_News.Destek.net...
> I have a query that will product a report broken down this way:
>
> 'store name' 'store number' 'store total' 'transaction type'
'#
> transactions'
> xyz 500000 $5,555.00 1
> 3
> $200.00 3
> 1
>
>
> my dilemma is this: there are 6 possible transaction type. I can break the
> report on transaction type so that any given store with more then 1 type
of
> transaction has them listed on a new line. (as shown above). I want to
> either, 1) at the end of the report to show report total count for type 1,
> 2, 3, 4, 5, & 6. or 2) modify
> the output so that each transaction type has it's own column. (that way
> excel can do a sum on the column)
>
> my choice is the 1 option. report just looks cleaner. But, I don't know
how
> to do that. HELP please....
>
> Thanks in Advance.
>
>
Received on Thu Nov 18 1999 - 16:09:20 CST