Missing Record in Crystal Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wrytat - 27 Sep 2007 03:23 GMT

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?

Reply to this Message

wrytat - 27 Sep 2007 06:01 GMT

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

> 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
[quoted text clipped - 5 lines]
> table, it wont show up in my Crystal Report. What should I do to let those
> record appear?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...