Hi, I have two reports with similar data, pulled from two different tables. 

I want to combine them to one report, but I've been unsuccessful in my attempts. 

Can someone comment on how to go about this?

Each report has product numbers, and qty's.  The same product number will sometimes be on both reports, and sometimes the reports will contain different product numbers. 

I want to simply integrate the reports so that each product has one total qty.  My trouble is that the first report pulls from table A and is unfiltered.  The second report pulls from table B and is filtered by various conditions.  When I try to query both tables from one report, the conditions intended to filter the second set also impact the query of the first table (is there a way to define a filter only to apply to a specific table?).  And if I try to run the second one as a subreport, I just get no data returned.  I'm not sure what to do, but it doesn't seem like it should be that complicated, so I'm not sure what I'm missing or doing wrong.

Any help will be appreciated.

Thanks!

Paul