I have to tables
vendor
ap
I have linked them up in database link on a key field vendor-num and said the vendor table is an outer join
In the report in the Select Expert: I have another requirement to state that AP record the field balance <> 0
Now Does crystal first do the outer join and get all the records.
Then it goes to the Select Expert and filters out more?
I wanted all the vendor records and and only those AP records with balance not 0. If no AP records for that vendor I still wanted the vendor record
It seems if AP record with balance of 0, the associated vendor record does not get selected.
A bit confused here
Any help is appreciated
vendor
ap
I have linked them up in database link on a key field vendor-num and said the vendor table is an outer join
In the report in the Select Expert: I have another requirement to state that AP record the field balance <> 0
Now Does crystal first do the outer join and get all the records.
Then it goes to the Select Expert and filters out more?
I wanted all the vendor records and and only those AP records with balance not 0. If no AP records for that vendor I still wanted the vendor record
It seems if AP record with balance of 0, the associated vendor record does not get selected.
A bit confused here
Any help is appreciated