Hello, I’m trying to create a single report similar to the Project Overview that would report on multiple, similar projects at once.
For example I am leading the renovation of multiple apartments. I would have a project file for each of the apartments. We are moving resources in stages and some are deployed simultaneously.
I’d like to run a single report that shows all of the upcoming activity, any late activity and the project status.
When I create a master report of a project file that has each apartment in as a subproject it gives me a summary in bar chart form of the completion status of each apartment but doesnt give me any milestones, upcoming or late tasks.
Is there anyway to do this from a single report? Thanks in advance!
Jerry, it’s been a while since the last time I worked with master projects but here’s a suggestion. Create a temporary master project by inserting the sub-projects without linking them (when you insert the project (deselect the Link to project checkbox). This will create a single project and allow you to report across all of them. You can either create the reports in a blank project or copy the report to your global to be able to reuse. Someone might have a more “formal, accurate, best practice” answer but this will at least get you the combined report you are asking.