I have two similar reports, the first one in CR 8 and the other in CR XI. They both address the same kind of Oracle DBases (in a one to many relationship), but in two different office locations.

Here's the SQL Query for the first report:

SELECT
     "NCAANGL1"."CONTAINERNUMMER",
     "NCAANGH0"."INTERNNUMMER"
FROM
     "NCTS"."NCAANGL1" "NCAANGL1",
     "NCTS"."NCAANGH0" "NCAANGH0"
WHERE
     "NCAANGL1"."INTERN_VOLGNUMMER" = "NCAANGH0"."INTERNNUMMER" AND
     "NCAANGH0"."DATUM_AANVAARDING_25_28" >= '20121001' AND
     "NCAANGH0"."DATUM_AANVAARDING_25_28" <= '20121031'


The second report is made with CR XI and shows following SQL Query:

SELECT
     "NCAANGL1"."CONTAINERNUMMER",
     "NCAANGH0"."INTERNNUMMER"
FROM     "NCTS"."NCAANGL1" "NCAANGL1" RIGHT OUTER JOIN "NCTS"."NCAANGH0" "NCAANGH0" ON "NCAANGL1"."INTERN_VOLGNUMMER"="NCAANGH0"."INTERNNUMMER"

WHERE     ("NCAANGH0"."DATUM_AANVAARDING_25_28">='20121001' AND "NCAANGH0"."DATUM_AANVAARDING_25_28"<='20121031')

Both reports have parameterfields for selection of the perioddates.

Now, the first report (in CR 8) does not show records in the main table that have no related record, while the second report (in CR XI) does!

Anybody any idea how to have the first report act as the second one?