Where do I specify the different companies to run the report in.

I created a container and the report and it is currently "auto connecting" meaning the report runs in the company in which you are.

I want the report to run the information on sheet 1 for company A and Sheet 3 for Company B and Sheet 4 for Company C.

Do I need to create 3 different reports and combine it into a union report or do I need to create 3 containers and in the container specify the company?  If so where do I do that?

Thanks in advance

Lize