My client has 3 standard consolidation reports connected to 3 different containers which they want to put together in a union report. 

The reason there are 3 different containers and associated reports is because there are different modules activated for different companies. 

For example:

Report A - Associated to Company 1,2,3 - Modules Active: AP, GL, PO, IC

Report B - Associated to Company 4,5 - Modules Active: AP, GL

Report C - Associated to Company 6 - Module Active: GL

I can't create a single consolidated report because Company 4,5 errors out because they don't have PO or IC active, and Company 6 errors out because it doesn't have anything other than GL active.

The 3 standard reports works individually, but when I try to create a union report of them, I get the info from the Companies 1,2,3  3 times. What it appears to do is run Report A for Company 1,2,3, then run Report B for Companies 1,2,3 (instead of for Companies 4,5) and then run Report C for Companies 1,2,3 (instead of for Company 6).

I have contact Sage support. They advised that I am not using the Union report as it is intended, so they are unable to assist with this issue. 

If anyone has any suggestion, please advise.  

I have attached some simplified screen shots for reference.