Create a Summary Report across 10 different projects

[Muddypaws]

Can a report be created over 10 seperate projects? Like the basic
Summary Report that you can use in Report, Overview, Project Summary.
I can get them individually, great. But I need to see the overall
summary for all 10 projects, is this possible

 

[John]

Can a report be created over 10 seperate projects? Like the basic
Summary Report that you can use in Report, Overview, Project Summary.
I can get them individually, great. But I need to see the overall
summary for all 10 projects, is this possible

Muddypaws,
It depends on the level of detail, but yes, it can be done. If all you
really need is schedule and cost information across the 10 projects you
can get that from the built-in Project Summary report by creating a
master file will all 10 projects inserted. To do that, first create a
new blank project file. Then go to Insert/Project and select all 10
projects. What you will end up with is a dynamically consolidated master
and you can either activate the Project Summary Task via
Tools/Options/View tab, or use the aforementioned built-in report. Be
advised that you will NOT get resource information using this approach
because there are no resources at the master level itself. All resources
are in each of the inserted subprojects. However, if you are using a
common resource pool file, you could run the report on the pool file to
get summary resource information.

If you want more detailed information and/or need resource data across
the 10 projects (in the absence of a common resource pool), you will
need to use VBA. If you do not have experience with Project VBA, fellow
MVP, Rod Gill has an excellent book on the subject. In it are several
examples for doing things like you want. For more information, see,
http://www.projectvbabook.com

Hope this helps,
John
Project MVP

 

[asep mr]

Dear,

how much project can insert in new blank gannt chart?

asepmr
habitat for humanity

 

[JulieS]

Hi asepmr,

I think you are asking what is the maximum number of project files that
can be inserted into a new master file. The software limitation is 999
inserted projects. However, unless the inserted project files have very
few tasks, that number is far larger than can realistically be managed,
in my opinion.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[JohnGaray-DecisionEdge]

For multi-project reporting, including resource information, I also (humbly)
suggest DecisionEdge for Microsoft Office Project.

All the 80+ bundled charts and reports can be used in a multi-project
scenario (with a master project and/or with completely separate project
files). There's no need to resort to custom VBA programming...

Here's a link for more specific information:
http://www.decisionedge.com/landing_microsoft_multiproject.html

Hope this helps!
Regards, John Garay