How to show Resource Rate on Gantt View?

[sqlhotdog2005]

How can I show each Resource's standard rate in the Gantt view?

 

[PDQBach]

The information on the Gantt chart comes from the task and task assignment information; the assignment information links resources to task.

And there's your problem: the assignment information is designed to link multiple resources (even if you only actually use only one at a time) to the task.

So you'll need some VBA to do the work and you'll need to decide what to do when there are multiple resources. So, use the VBA to grab the resource standard rate and stick it into a task field (number1, for example) and then click on Format | Bar styles ... and make the necessary changes.

 

[sqlhotdog2005]

Ouch. Thanks for the advice... I'll have to tackle VBA another day.

 

[PDQBach]

VBA isn't so bad (he says after playing and playing for quite some time).

You could, of course, simply maintain the values manually in a field like Task Number1 (after all, how often do the rates changes) and then display that on the Gantt chart.

 

[sqlhotdog2005]

Ding, ding, ding.... thanks for the suggestion of the manually entered rates... how obvious is THAT?! Just in too deep here... can't see the forest for the trees.

Thanks!