Tracking % Complete Over Time

[Jessica]

I have a report request that a user wants to track BCWP over time(this report will be done in Crystal Reports). If the value of BCWP = % complete x budget then I will need to track the values of % complete over time. I am told that project does not store historical data for the values of % complete as they are entered at the task level and calculated at the project level. I will definitely not be able to get my PM's to baseline each time either.

Can I create an update trigger on the % complete field in the database and insert a line into a history table that contains the % complete value and the date it was updated? Is there any other way to track this data over time? I am using Project Server 2003. Any help is appreciated. Thanks

-Jessica

 

[JackD]

The baseline should only be set once. Why not just run the report every week
and save the values off somewhere? You could make another table in the
database for this or even put it into a spreadsheet.

-Jack

I have a report request that a user wants to track BCWP over time(this

report will be done in Crystal Reports). If the value of BCWP = % complete
x budget then I will need to track the values of % complete over time. I am
told that project does not store historical data for the values of %
complete as they are entered at the task level and calculated at the project
level. I will definitely not be able to get my PM's to baseline each time
either.

Can I create an update trigger on the % complete field in the database and

insert a line into a history table that contains the % complete value and
the date it was updated? Is there any other way to track this data over
time? I am using Project Server 2003. Any help is appreciated. Thanks.