Joshua... my technique is to create a "working table" from the various tables that you are trying to consolidate and then create the report from that. Use a SELECT statement to get all of your data into a final table, (or cursor). Then create the report.
This technique uncouples the "gathering the data" part from the "formatting the report" part, and can save you a lot of time and confusion messing about with the report writer.
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.