Missing Record in Crystal Report

[Guest]

I have a Crystal Report, which DataSource is made up of 2 tables, 1 Header
table and 1 Detail table. The Detail table contains extra details of the
items in the Header table. Not all Header items has a record in the Detail
table. As for my Crystal Report, I'm grouping the records by the Header
table's primary key (which is linked to the Detail table).

I discovered that for those items that does not have a record in the Detail
table, it wont show up in my Crystal Report. What should I do to let those
record appear?

 

[Guest]

I've found out the reason. I have to define Outer Join at the database expert
of the report. Thanks.