#1
|
|||
|
|||
Trying to get 3 layers of subprojects with a workaround.
I am trying to outsmart Project and get 3 layers of subprojects for reporting.
1. I have 45 subprojects which are dependencies which need to be done before other work can start. 2. I have 93 projects which each require 6 to 12 subprojects as predecessors. Everything works well up to this point. Now, I would like to have a summary schedule (3rd level) of the 93 projects for reporting purposes only. I would not manage or edit from the summary, but just use it for monthly reports. If I try to create the create the summary schedule one project at a time, as soon as another project is added which share a subproject already in place, i get the error message, that multiple copies of a subproject are not allowed. Understood. If I add all the projects at one time, however, all 93 will load. The first instance of each subproject will remain a subproject, with all other instances of that subproject breaking the link and becoming only a single top-level task. This destroys pretty much all of the links. I am OK with this, since for reporting I planned to 1. update my subprojects. 2. update my projects. 3. copy the projects to a separate reporting directory, where the links to the subprojects remain live, but as I build the summary project as above, the links break on the reporting projects, not the master file. Anyway, it all seemed to work, with the subprojects that collapsed to tasks still retaining their finish dates so the summary project would maintain schedule logic. However, I noticed that some of them work fine, while some of the dates collapse to an arbitrary date, or the project start date, and I cannot find any logic to that. See the attachment, where lines 4, 5, and 7 collapsed with correct dates, line 6 is a subproject (the first instance), but lines 10 -12 all default to some arbitrary date (a previous finish date for one of line 10. I know I am stretching the limits of MSP this way, but wonder if any can help, or offer an alternate way to get a summary schedule at the 3rd level. |
Tags |
subprojects, summary |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subprojects columns being mixed up | hpatel517 | Project | 5 | 08-21-2016 05:37 AM |
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC | Story11 | Excel Programming | 37 | 01-26-2015 09:34 PM |
Index Hyperlink Workaround | Phil H | Word VBA | 9 | 10-30-2014 05:14 AM |
Workaround to have UserForm open from Web Link | Kirsti | Word VBA | 11 | 08-23-2012 07:05 PM |
Pls Help!! Inserting Subprojects... | Dina | Project | 1 | 01-20-2011 09:55 AM |