Project 2003 Custom Summary Report

[BitHack]

Does anyone have any info/link on creating a custom report in Project 2003? I am using the "Standard Rate" field in the Resource Sheet as my "Hourly Rate" for each resource. The Summary Report calculates the cost of a resource from this field. I want to be able to modify this value by a simple modifier (multiply by 1.5) and be able to create a report similar to the Summary Report using this number.

Is there anything available in VBA. My first attempt was to create a new Rate_1, which can be easily modified, but, I can't get that value into a report.

Any ideas/links would be appreciated.

Thanks

 

[PDQBach]

The Summary Report cannot be edited.

Using VBA you'll have two tasks to perform:

1. get lots of info from activeproject.projectsummarytask.XXX where xxx is a variety of fields including Start, Finish, Cost, etc.

2. loop through all tasks (ignoring Summary tasks) and total up whatever values you need such as the count of tasks not yet started, tasks in progress, etc.