How to get Task Hour Cost of a Resource

[boni]

Hi,

I need actual work and actual cost of a resource in a project for a
particular task. I am getting actual cost from time sheet data in table
"Msp_View_Proj_Assn_tp_by_day" of Project Server 2003 database.

The problem is when I update the standard rate of a resource using Microsoft
Office Project 2003 and republish the project information; cost information
against tasks is updated using recent standard rate, as it does preserve the
cost/resource rate history.

For example if standard rate of Steve Masters is $70/hr and he works 8 hours
on a particular task then I get the cost $560.00. When i update the standard
rate to $80/hr and republish the project then i get the cost $640.00 for the
same task.

However the previous data should not be updated after revising the standard
rate. Is there any way that after updating the standard rate of a resource,
cost information of old task remains the same?

 

[Mike Glen]

Hi Boni,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP