Exporting/Reading percentage completion data in the SQL database

[DM]

Hello,

does anyone know which tables I'd look at to see the costs to date on a
project assuming I update it using percentage completion? i.e. I have a
$100k project and am 61% complete - somewhere there should be the data that
shows $61k of costs have been incurred - anyone know which table this
information is in? I assume this table would show information for the
summary task, and sub-tasks?

Thanks

DM

 

[Rod Gill]

in Project 2007 server, look in the reporting db. The View
MSP_EpmTask_Userview is best. You are looking for ActualCost

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com