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?

RE: Missing Record in Crystal Report by wrytat

wrytat
Wed Sep 26 22:01:01 PDT 2007

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

"wrytat" wrote:

> 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?