I may be trying something that can't be done : )
Using: CR2008, Oracle.
I have a main table called Master. From there, I have a Customer table, a Platform Table and Application table. The Master has an ID. Customer, Platform and Application records spawned from Master share a common ID (key).
For every record in the Master, there can be:
one corresponding record in the Customer, Platform and or Application tables
OR
many records in Customer, Platform and or Application tables
OR
no records at all.
So for instance when there is no corresponding Platform record, I get no records at all in the report... not even information from the Master. In order to get a record to show in my report, you must have at least one Customer record, Platform record and Application record.
I'd like for my report to show records even when the Customer or Platform or Application tables lack a record. Is this possible? My thinking is it's a join type problem... but I have not been able to figure this out. Thanks for your help.
Using: CR2008, Oracle.
I have a main table called Master. From there, I have a Customer table, a Platform Table and Application table. The Master has an ID. Customer, Platform and Application records spawned from Master share a common ID (key).
For every record in the Master, there can be:
one corresponding record in the Customer, Platform and or Application tables
OR
many records in Customer, Platform and or Application tables
OR
no records at all.
So for instance when there is no corresponding Platform record, I get no records at all in the report... not even information from the Master. In order to get a record to show in my report, you must have at least one Customer record, Platform record and Application record.
I'd like for my report to show records even when the Customer or Platform or Application tables lack a record. Is this possible? My thinking is it's a join type problem... but I have not been able to figure this out. Thanks for your help.