FAQ
I have to create a tabular quarterly summary report, based on 4 different queries, but all are grouped by the same columns.  Any suggestions on how to accomplish this - sql report etc.    Thanks a lot.
Type    category    Col1   Col2    Col3     Col4
Elec      Fac           500      100          200        400
Elec     Rates         300     200           50         450

Elec     Fran          200     100         50         250
Gas      Fac           700       300        200         800
Gas     Rates        900     100         600        400
Gas   Fran           400      100          300        100

Col1 is count of open cases at start of quarter grouped by type and category
Col2 is count of new cases opened during quarter grouped by type and category

Col3 is count of cases closed in the quarter grouped by type and category

Col4 is count of open cases at end of quarter grouped by type and category

Col1 query is:
select type, category, count(*) form case where status='Open' and date_filed<'01-Jul-02' group by type, category;
Col2 query is:
select type, category, count(*)  from case where date_filed>='01-Jul-02' group by type, category;
Col3 query is
select type, category, count(*) form case where status='Closed' and date_closed>='01-Jul-02' and date_closed<='03-Sep-02' group by type, category;
Col4 query is
select type, category, count(*) form case where status='Open' group by type, category;




Chat with friends online, try MSN Messenger: Click Here
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erma Fernando
INET: cecfernan@hotmail.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 4, '02 at 4:18p
activeOct 4, '02 at 7:44p
posts3
users2
websiteoracle.com

2 users in discussion

Erma Fernando: 2 posts Sunny Verghese: 1 post

People

Translate

site design / logo © 2022 Grokbase