Crystal Reports How to extract table information correctly

Message

     Hi, 

The case is a little bit confusing here. So i would try my best to explain it. I need to create a Monthly Invoice Report.

Table X - Shipment Table
Table Y - Multiple Shipment to One Invoice Table
Table Z - Invoice Table

I created 5 shipments. Shipment numbers are Ship-01 to Ship-05. Ship-04 and Ship-05's invoice number are Inv-04, while Ship-01 = Inv-01,  Ship-02 = Inv-02 and Ship-03 = Inv-03. 

Table X:-
Shipment Number 
Ship-01 
Ship-02
Ship-03
Ship-04
Ship-05

Table Y (It only store info that "multiple shipment to one invoice", it would not store info for "one shipment to one invoice"):-
Invoice Number / Shipment Number
Inv-04 / Ship-04
Inv-04 / Ship-05

Table Z:-
Invoice Number / Shipment Number
Inv-01 / Ship-01

Inv-02 / Ship-02

Inv-03 / Ship-03

Inv-04 / Ship-04

Here come the problem...
I grouped Table Z.Invoice Number and put Table X.Shipment number at details. 

If my database link relation is 
Table Z.InvoiceNumber -> Table Y.Invoice Number
Table Y.Shipment Number -> Table X.Shipment Number
Details for Inv-01 to Inv-03 won't appear, it only show Inv-04's details which is Ship-04 and Ship-05

If my database link relation is

Table Z.Shipment Number -> Table X.Shipment Number

Table Z.InvoiceNumber -> Table Y.Invoice Number
Table Y.Shipment Number -> Table X.Shipment Number
Details for Inv-01 to Inv-03 appear, but Inv-04 only show Ship-04. Ship-05 is missing.

All table link is left outer join, no enforced, link type is (=)

Please guide me how to show all details info correctly.

Hope my explaination above was clear, thank you

Edited by stepzie - 08 Sep 2009 at 3:42am