MS Projec2007 > Visual Reports

[Hardip]

Hello All

I'm playing with Visual Reports. Is there a method to report across
multiple projects if I create a master schedule? I've set up a sample master
schedule and inserted 4 projects. However, when I export to Excel I don't
see the options.

Thanks to the usual peeps that help!

Cheers, H

 

[JulieS]

Hi H,

What "options" are you missing?

Julie

 

[Hardip]

Hey Julie

Super question... In reality I'm not sure what options there should be or
what I should see (doh).

I've created 4 very basic project files and inserted them into a master
schedule. I'm using the basic reports available - the one to do with
resource work.

In Excel I'm only seeing the first project I inserted and not projects 2-4.
I'm also getting some spurious results for work that exceed the values in MS
Project.

I'm clearly doing something wrong here - not for the first time.

I could send you the file if you have time to review my blunder? <oh dear>

Thanks for again for getting back to me.

Speak soon, H

 

[JulieS]

Hi H,

Well, I'm sorry to say that you may not be doing anything
incorrectly at all. I could reproduce what you report under the
following circumstances:

Each file was a copy of a single saved and renamed through File >
Save As. I created a relatively simple file -- 2 resources, 2
summary 4 sub-tasks. I then saved the file through File > Save As
as 4 separate project files. Even when I changed resource names,
task names and Project start dates, the consolidated file only shows
the first 2 resources.

However, when I made 4 completely new files it appeared to work
correctly, although I will say I had a fairly high occurrence of
other odd behavior. Once the consolidate project did not show any
work for two of the resources. I unassigned and then re-assigned
each resource from a single task and miraculously all work
re-appeared.

This is using Project 2007 SP-2

There were some postings as far back as June 2008 with some
significant issues with the visual reports exhibiting bizarre
behavior with consolidate files.

So, good news -- it's not you.

Julie

 

[Hardip]

Hi Julie

Thanks for the feedback. I tried your suggestions and its working great. I
can now get display the programme view by project - super dooper!

I have a quick one for you. I've created the following pivot:

Tasks Tasks 01 Year Work Cost
Programme Project1 2009 96 960
Project2 2009 96 960
Project3 2009 96 960
Project4 2009 96 960
ProgrammeSchedule Total 384 3840


When adding the Earned Value fields such as PV I'm getting a PV per project
of 2480. Thats odd given the work and cost data is correct. Is this another
quirk or something with the projects I've set up?

Each of the project was baselined individually and then I baselined the
ProgrammeSchedule after inserting Projects 1-4, as there was no EV info
flowing through with a baseline. Also my project are linked.

Would appreciate your thoughts.

Cheers, H

 

[Hardip]

Hi All

I fixed it. Actually, there was nothing to fix as I added resources to
milestones in haste and it screwed up the EVM numbers!

 

[JulieS]

Good to hear you've straightened it out H.

Julie

Hi All

I fixed it. Actually, there was nothing to fix as I added
resources to
milestones in haste and it screwed up the EVM numbers!

 

[Hardip]

And thanks again as I managed to fathom why the AC output was 0 and duly
changed the status date in MS Project, restarted, fired up the report and it
was all there - correct <hooray>. So thats a previous response to a post you
supplied - your good!!!!

The funny thing is that all this work I'm doing in my own time isn't
required as part of my current contract. I've always been able to use MS
Project to schedule and have used some of the bells & whistles, but all these
additional features are must know items for me. My goal is to create an
informative and insightful programme dashboard to report all projects.
Naturally, I'll stumble upon MS Project Server at some point.

I aim to go to India and do MS Project courses when I'm out of contract and
certify - work and play! I've found a highly reputable training
organisation in India (http://www.koenig-solutions.com). I like the sound of
Goa and MS Project/Server training <haha>

Thanks for all the help Julie. When the times right all the food and meals
will be on me! And I'd invite a few others from here as well

Cheers, H

 

[JulieS]

Superb H, I'll look forward to it

And thanks again as I managed to fathom why the AC output was 0
and duly
changed the status date in MS Project, restarted, fired up the
report and it
was all there - correct <hooray>. So thats a previous response to
a post you
supplied - your good!!!!

The funny thing is that all this work I'm doing in my own time
isn't
required as part of my current contract. I've always been able to
use MS
Project to schedule and have used some of the bells & whistles,
but all these
additional features are must know items for me. My goal is to
create an
informative and insightful programme dashboard to report all
projects.
Naturally, I'll stumble upon MS Project Server at some point.

I aim to go to India and do MS Project courses when I'm out of
contract and
certify - work and play! I've found a highly reputable
training
organisation in India (http://www.koenig-solutions.com). I like
the sound of
Goa and MS Project/Server training <haha>

Thanks for all the help Julie. When the times right all the food
and meals
will be on me! And I'd invite a few others from here as well

Cheers, H