you mean in your select you are using
tableA.field <> 'contract type 1'
you can change the select formula option to 'use default values for nulls'
If you are using any other select criteria it may start dropping other records out and you would be better off using a command or stored proc as your data source and move the condition from the WHERE to the join for that table
Example:
select A.Field1, A.Field2,B.field1,B.field2,C.field1,C.field2
from
Table1 as A
LEFT JOIN table2 as B oN A.field=B.field and B.Type <>'xxx'
LEFT JOIN table3 as C ON A.field=C.field
Edited by DBlank - 03 Dec 2014 at 7:25am