What I do when I need to create reports with objects from several sheets (in your case, from a container) is to create a hidden sheet where all these objects are, formatted to best fit within the report to be printed, and use them.
In the case of the container, you will have to use the chart from outside to container to drag it onto the report area.