Composite Reporting

From: Dianne <Dianne_C_Kelly_at_raytheon.com>
Date: 5 Jan 2004 10:16:22 -0800
Message-ID: <1edb724c.0401051016.40e75c2_at_posting.google.com>

[Quoted] Using Oracle 9i and Oracle Discoverer or Oracle Reports (or other tool) is it possible to create a single composite report that combines records from multiple tables when each table has a different number and type of fields? For instance, can you create a report that looks like this:

TimeOfDay:xxx  TableNumber:88   Field1:12.34   Field2:ABC   Field3:698
TimeOfDay:xxx  TableNumber:61   Field1:ABC
TimeOfDay:xxx  TableNumber:22   Field1:47      Field2:9847
TimeOfDay:xxx  TableNumber:88   Field1:4.56    Field2:DEF   Field3:29

...

This example is pulling records from three different tables (#88, #61 and #22) and then sorting the results by TimeOfDay. Received on Mon Jan 05 2004 - 19:16:22 CET