| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Discoverer Report Query
Hi All,
I need to create a report in Oracle Discoverer. I would like to know if it is possible to create a report with the following logic. If yes, then how do I go about creating a report.
I have a table TBLREPORT with the following structure from which I have to pick up records.
Table: TBLREPORT
dttime DATE
interval VARCHAR2(10) (The field will have values BASE, HOURLY)
rdvalue number (aggregate to be applied in business area is AVG)
Data in table:
Dttime interval rdvalue 20-AUG-2001 9:00 am HOURLY 10 20-AUG-2001 10:00 am HOURLY 20
21-AUG-2001 9:00 am HOURLY 20
21-AUG-2001 10:00 am HOURLY 30
22-AUG-2001 9:00 am HOURLY 10
22-AUG-2001 10:00 am HOURLY 20
23-AUG-2001 9:00 am BASE 10 23-AUG-2001 9:15 am BASE 20 23-AUG-2001 9:30 am BASE 30 23-AUG-2001 9:45 am BASE 40
23-AUG-2001 9:00 am HOURLY 25 (the base data for 23-AUG-2001 from 9:00 am to 9:45 am is rolled up to arrive at HOURLY data e.g. 10+20+30+40 = 100/4 = 25)
23-AUG-2001 10:00 am BASE 50 23-AUG-2001 10:15 am BASE 60 23-AUG-2001 10:30 am BASE 70 23-AUG-2001 10:45 am BASE 80
23-AUG-2001 10:00 am HOURLY 65 (the base data for 23-AUG-2001 from 10:00 am to 10:45 am is rolled up to arrive at HOURLY data e.g. 50+60+70+80 = 260/4 = 65)
24-AUG-2001 9:00 am BASE 10 24-AUG-2001 9:15 am BASE 20 24-AUG-2001 9:30 am BASE 30 24-AUG-2001 9:45 am BASE 40
24-AUG-2001 9:00 am HOURLY 25 (the base data for 24-AUG-2001 from 9:00 am to 9:45 am is rolled up to arrive at HOURLY data e.g. 10+20+30+40 = 100/4 = 25)
24-AUG-2001 10:00 am BASE 50 24-AUG-2001 10:15 am BASE 60 24-AUG-2001 10:30 am BASE 70 24-AUG-2001 10:45 am BASE 80
24-AUG-2001 10:00 am HOURLY 65 (the base data for 24-AUG-2001 from 10:00 am to 10:45 am is rolled up to arrive at HOURLY data e.g. 50+60+70+80 = 260/4 = 65) Received on Fri Sep 07 2001 - 01:01:30 CDT
 |
 |