SQL*Report ... how to print detail records across

From: Gv Fragante <fragante_at_unixg.ubc.ca>
Date: Thu, 3 Sep 1992 17:00:47 GMT
Message-ID: <fragante.715539647_at_unixg.ubc.ca>

I have a master/detail relationship which I have to print in the following ways:

master records print downwards

detail records print across each master record and *must* be on the same line

For example, I have the following master records and corresponding details

MASTER DETAIL American Cars Ford

                GM
                Chrysler

Japanese Cars   Honda
                Toyota
                Mazda

German Cars     Mercedes
                BMW
                Audi

So in my report output, it should look like this:

American Cars Ford, GM, Chrysler
Japanese Cars Honda, Toyota, Mazda
German Cars Mercedes, BMW, Audi

I have come close to achieveing this but the problem is that the detail records are printed below the master record. This is not quite what I need.

The reason why I need this output format is because the data will be imported into an Excel spreadsheet wherein one Excel row will contain one Oracle master *AND* it's details. BTW, the max number of details in my situation is 6, so I'm not worried about the variable length of the SQL*Report width.

Any suggestions would be greatly appreciated. Thanks. Received on Thu Sep 03 1992 - 19:00:47 CEST

This message: [ Message body ]
Next message: Thierry Lach : "Re: SQL*Report ... how to print detail records across"
Previous message: pihlab_at_hhcs.gov.au: "Re: Name of trace file currently being written."
Next in thread: Thierry Lach : "Re: SQL*Report ... how to print detail records across"
Reply: Thierry Lach : "Re: SQL*Report ... how to print detail records across"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message