Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tailoring MS Project Report - possible code change

Status
Not open for further replies.

strugglers

Programmer
Sep 1, 2003
3
US
hi all you expert MS Project users that have helped me tons in the past! :eek:)

Need your help once again for the following problem:

I have generated a customer report in MS Project that shows all tasks contained in 'work package A' which have predecessors that are outside of work package A, i.e. they are linked from a seperate work package (e.g. Work Package B) which is owned by someone else. In order to get this, I tick the 'predecessors' checkbox under 'task' on the 'details' tab of the custom report.

Although this works fine, the only attributes shown on the final report for the predecessor information is 'ID, Predecessor name, Type and lag'. This is ok but I need it to show the start date of the predecessor task plus other info. I've looked in the tables option to see if the data is pulled from a 'predecessors table' of some sort but no luck and looked under all other possible options but still can't find a way to taylor this information.

I assume the data is hard coded into MS Project and therefore can't be modified.

Please let me know if there is anyway of modifying this predecessor data because it is slowly driving me insane.

Thanks in advance for your help and taking the time to read this.

Regards (as always)

Matt
 
I played around a bit and couldn't find an easy way to show the information you want on a custom report. (In all honestly, I couldn't find a hard way either!)

The information is available but it appears you'll need to code some VBA to access it.

activeproject.task(SomeTaskNumber).PredecessorTasks.Count will tell you how many predecessor tasks you have for task ID "SomeTaskNumber"

activeproject.task(SomeTaskNumber).PredecessorTasks(Nmbr).Start give you the Start attribute of predecessor information (Nmbr will go from 1 to the .Count number shown above allowing you to 'step through' each Predecessor; 0 means that there are no Predecessors).

I know this isn't the answer you want, but it is an answer that will help you get to the information you need.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top