click on the links between the databases, I think that they are tables, but in the link you will need to play with the joins. I always get confused in the screen, but you want an outer join. An inner join will only show the transactions between the tables that match. An outer join gives everything in one table and the matches to the other tables.
Why I get confused, is that it probably how you drew the link, but in SQL a left join is take everything from the table on the first table (the one on the left side of the page) and the matching records in the table on the right. Anything that doesn't match has a value of NULL.
Try it one way and if it doesn't improve the report, try it the other way, it should work then.
HTH
IP Logged
