Left Outer Join Problem

[elaineva]

I have linked Table A left link to Table B. Report Record Selection formulas from Table A produce the correct results (i.e.Record from Table A without matching Record from Table B) - but when I add a selection formula using Table B - it appears to loose the left join and I no longer get records from Table A without matching Table B record. What am I doing wrong??

 

[princessinthetower]

You can't apply a selection to table B without nullifying the left outer join. It becomes an equal join so that you will get only records in table A that match in table B. Do you need to select on table B? There may be another way to accomplish what you want.

 

[elaineva]

Yes, I do need to select on Table B, as well as Table A. Any help on solving this problem would be greatly appreciated. Thanks Infobabe.

 

[kenhamady]

Options that I see.

Use a subreport to pull info from table B.

Expand the selection criteria for table B so that every record in A will have at least one qualifying match in B.

Eliminate the selection on table B completely, pulling all B records, and then suppress the ones that you don't want to see.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com