To get all four tables in one report is going to be a bit tricky. You are going to need to use a SQL Command object (instead of adding the tables to the report, you will use Add Command to add a query).
The query will look something like:
SELECT * FROM
(SELECT * FROM invoice
UNION ALL
SELECT * FROM dyinvoice) inv_union
JOIN
(SELECT * FROM gl_invoice
UNION ALL
SELECT * FROM dy_gl_invoice) gl_union
ON inv_union.inv_num = gl_union.gl_num
If you've never used UNION before, you need to know that the columns for both halves of the UNION need to line up. E.g., you can't have an extra "date archived" column in the middle of the dyinvoice table. For that reason, never actually use the "SELECT *" phrase. By listing out the columns, it is much easier to make sure they line up.
IP Logged
