Exporting/reading percentage completion data

[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

 

[Paul Conroy]

The cost table will show you actual costs to date.

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[DM]

Is this for Project 2003 or 2007? We're using 2007 and I cant see a tabled
called 'cost'??

Thanks

 

[Paul Conroy]

this works for both 2003 and 2007.

From the menubar select, view > Table > Cost.

If you can't see the cost table, select "more tables" from the same menu.

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[DM]

Ah - sorry, I meant within the SQL tables - I want to have access to the
data to export into Excel or be made available to another SQL database such
as a finance package.

Thanks

DM

 

[Paul Conroy]

From memory, in EPMProject_UserView in the Reporting Database, look for an
actual cost column.

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com