create report for a group of developers

[blom0344]

We have our development planning stored in MS Project.
I would like to create weekly reports for each developer (resource) to give themn insight into what has been assigned to them.

The reports should therefore contain:

1. Resourcename (developer)
2. Taskdescription
3. Startdate of the task
4. Duration
5. Notes on the task

taskdata displayed should contain tasks in progress and tasks with startingdate in the future. (All tasks that are 100% complete should be excluded)

Has anyone been able to get this type of data out of Project. I see that reporting through XML is an option, but I am not at all familiar with XML.

Suggestions, hints?

Ties Blom

 

[PDQBach]

There are two ways to accomplish what you want

1. Slightly reduce your requirements and look at the built-in report "Who Does What". You won't get the duration but you will see Start/Finish. The Notes you see are the *Assignment* notes and/or the *Resource* notes (depending on the options you select) but not the Task notes. If this is acceptable then you'll have to change the filter "Resources - Work" to include only those items where %WorkComplete does not equal 100. It's not the greatest report but it may prove workable for you.

2. Write some VBA to create the exact output you require. If you're an experienced VBA coder and understand the Project object model, it shouldn't take too long (i.e., you should be seeing something useful in an hour). Your only issue will be handling the Notes which are stored as a RichText field. I've not written any VBA to handle Notes so I don't know how difficult it will be.