Missing Record in Crystal Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I've found out the reason. I have to define Outer Join at the database expert
of the report. Thanks.
 
Back
Top