Multiple table report question 1

[GEKLAW]

Hello everyone,

I am a fairly new user of crystal and would appreciate any help. I need to create a report that pulls from three tables; I will call them the contacts table, party table, and the client table. All three tables are linked via contact_id. The contact table has some records that are clients and some that are parties. I need to write a report that displays all the contacts that are not clients or parties.

I am using crystal reports pro ver 9 and I am reporting off of a sql database.

Thanks in advance for any help.

 

[lbass]

Use a left join FROM Contacts to Parties and a left join from Contacts to Clients. Then go to edit selection formula->record and enter:

isnull({Parties.ClientID}) and
isnull({Clients.ClientID})

-LB

 

[GEKLAW]

This worked great. Thanks!