Running Union Consolidation reports with different companies in Sub-Reports

Hi Everyone,

I have only just noticed that when running union consolidation reports, if you have different companies selected in your sub reports, the union report will only return data for the companies selected in the first report that is run.

I can think of a number of ways around this, but is it not possible to run the report based on the companies selected at the sub-report level?

Many thanks,

Ian Barbour

Views: 141

Reply to This

Replies to This Discussion

Hi Ian 

If I understand the above correctly you may want to apply Pass Through variables to your report so you could then pass the company name into the report and filter the sub report further. 

Check out this webcast on pass through variables : Pass Through Variables and how to use them

If you need further assistance please contact me on 



Hi Carmen,

The problem is more to do with the way the databases are selected when using Consolidated containers.   When you have a Union report, each Sub report has databases selected in the "Database Consolidation List".   When the Union report runs it only looks at the Databases in the first sub report that is run and then uses these in all the other reports.

With the report that I am running, not every database has the same tables and therefore some of the sub reports fail.   To get around this I have hard connected some of the containers to the databases rather than use AutoConnect.   This resolves the issue, but what I would like to confirm is that with Union Consolidation reports you really only need top select the Databases for the first report that is run.

Many thanks,


Hi Ian,

I have a Consolidated container and have created a report with one table that is consistent to all companies.  My 10 sub union reports are 10 data different Sage 100 companies, version 5.20.   I am finding out that it does not work and only looks at the first company chosen. What do you mean by "hard connected" to make this work?


Paula Park

Hi Paula,

I'm not sure how your connectors work in Sage 100, but with Sage 300, when you set up a Connector you can select the Auto Connect option or, if you want a specific database, enter the database details in the setup.

This allows me to have a hard coded connection to a specific database and any containers in that Connector will only return data for that database.   In that way I was able to get disparate data from different companies.


Thank you Ian.  Yes, i believe the setup is the same.  I have Auto Connect selected for my Consolidated Connector.  Then my container was created with the one sales table.  But when I create a Union report, with 10 archived copies of the companies, it only provides the year for the (first one) listed.  So if I randomly place 2007 archived company for the first Union Report, Sage Intelligence just uses that archived year, and ignores the rest.  If I put 2010 first, then only 2010 is returned.  Does not make programming sense to me.


Hi, if you are looking for consolidation and currency conversion of Sage 300 companies, we have several clients doing it. You can email me to


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service