Urgent.Error!! when different numbers of records in 3 tables?

[laurax]

Hi,
I am new to Crystal report. I am using Crystal report XI evaluation version, before the purchasing.
But I met a problem for creating report.
I have, say 3 tables: A, B, and C. (FoxPro 2.6 DBF files)
A has CaseNumber as the primary key.
B and C also use CaseNumber as the primary key.
They are linked by this CaseNumber.
A have 100 records. but B and C has less record depending on the real situation. (Records in B and C are only created when needed.)

when creating a report using data from A, B and C. I need to have a report for each record in A, even though there are no such CaseNumber in B or C.

But it seems that only the minimun number of reports can be created, which is the minimum number of records in B and C.

How to solve this problem?

It is very urgent.
Thanks

 

[IdoMillet]

Change the join properties to an OUTER join.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[laurax]

Seems a good idea.
How to do this in Crystal report? I couldn't find where to do this.

Sorry for this stupid quesiton.

 

[IdoMillet]

Database, Database Expert...

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kskid]

Make sure table A is on the left and tables B and C are on the right when you make the links.

right click on the links and click on link options and select Left outer join

-lw