asked on

display records that exist in table a but do not exist in table b

Hi There,

I'm using Crystal Reports XI.

I've got two tables and want to create a report which displays all the records in table a that do not exist in table b.

Is this possible?

thanks! Kristin

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

forcedexposure

ASKER

I want to go with option # 1 because i don't have the luxury of creating views in my tables.
but option #1 doesn't work... it's displaying all the records from table b that don't match table a. So there are 4012 lines of data when there are only 59 records in table a.

help?

Mike McCracken

A Crystal command is built in Crystal not in the database.

Can you upload the report

mlmcc

James0628

Assuming that you used the correct field(s) to link table A to table B, in that direction, and made it a Left Outer join, then it seems like mlmcc's suggestion should have worked. I believe you could also use IsNull ({TableB.Field}) in the record selection formula (instead of using suppression). I've done that before for just this kind of thing and it worked for me.

James

forcedexposure

ASKER

Hi There! I reread your suggestion and got it to work. My problem was that i needed to do left outer joins on two sets of fields from Table A to Table B.

Thanks for your patience and your help!!

best wishes, Kristin