Crystal Reports linking problem

[mick8001]

I'm creating in report in Peachtree. I have the tables linking w/Chart being the main because that is where the account code is and the report is grouped by account code. Anyways, the report is not pulling over all the account codes for the vendors. I've tried the left outer join and that doesn't work. Should I changge my "From" table to the table that has the invoices numbers in it?

 

[mick8001]

I am using Crystal XI.

 

[Madawc]

A 'left outer' from Table A to Table B should get accounts that only exist in Table A. But if you also do a selection test on Table B, it will hit nulls for accounts that only exist in Table A. Crystal formulas stop without warning or output when they hit a null.

You can get round this by including a test for null in your selection test.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10