help on Oracle Report 2.0

From: Judith Rimpler <jr4_at_irz.inf.tu-dresden.de>
Date: 27 Mar 1995 11:17:08 +0200
Message-ID: <3l5vqk$2jl_at_irz203.inf.tu-dresden.de>

Hi,

I'm trying to build reports using Oracle Report 2.0 on MS-DOS. I have the following problem:

        SELECT a.t1,b.t1,
                a.t2,b.t2,
                a.t3,b.t3,
                a.t4,b.t4,
                ...
                FROM a,b
                WHERE a.id=b.id
                        (selects one record of each table)

If the value of a column of table a is null then the value of the corresponding b is null as well. (example: a2 is null then b2 is null) I don`t want empty lines in my report. If a2 is null the report should look

like    a1      b1
        a3      b3
        a4      b4
        ...

(I`m dealing with very large records, I don't get the whole record on one page, so I have to split it.)

I know that it was'n possible at alL in SQL*Report 1.* and I couldn't find out if this should be possible in the new Version.

Can anybody help me to get ORACLE to do this?

Thanks

Judith Received on Mon Mar 27 1995 - 11:17:08 CEST