etc said:
Hi,
I would like to know if there is a way or if it is feasible to create a
custom report that is a summary of selected tasks. For example, I would like
to select certain tasks in my project (say tasks 2-16) and have a custom
report that shows the percentage of human resources, material resources, and
the cost associated with each for this group of selected tasks.
Thanks!
etc,
Is it possible? Yes. The exact method of implementing such a report may
vary. It definitely can be done using VBA however it may be possible to
get pretty close to what you want with a few spare fields, perhaps a
formula depending on whether the labor and material resources are both
on a given task or separated into separate tasks, and grouping.
I assume you want this report in a Gantt type of view. Here's an outline
of a non-VBA approach.
1. Use a spare field (e.g. Flag1) to identify the desired tasks
2. If both labor and material resources are combined on tasks, you will
need a couple more spare fields customized with a formula to separate
out the two resource types from the Resource Names field.
3. If labor and material resources are not combined on tasks, you could
either use a simple formula to capture the desired percentage data and
dump it into spare fields
3. Once you have those set up, use the grouping function to create a
summary line for just those tasks. You might also want to include a
filter to isolate the desired tasks.
Give this a shot and see if it gets what you want. I didn't try an
example, so I don't know if I've missed a relevant element in this
process.
John
Project MVP
