Baseline work and cost from Project server

[Arulraja]

I am working on a report generation tool from Project server. I need to get
all the base line work for a project, if it has a baseline saved. I need the
query for getting the basline work.
Thanks in advance

 

[Rod Gill]

Which version of Project Server, 2003 or 2007? What is the tool being
written in, .Net, Excel....?

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Arulraja]

I am using Project server 2003 and the tool i designed is in VBA with Excel
2003.

 

[Rod Gill]

Hi,

To get total baseline work for a project, read the MSP_VIEW tables in
Project Server. See pjsrvr.htm in one of Project's program folders. When you
upgrade to PS 2007 you will need to re-create the SQL Server Views to read
from the 2007 reporting database, otherwise this method of reading direct
from SQL Server will let you upgrade to 2007 and it will still work (with
the updated view(s)).

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Arulraja]

Thanks a lot

Hi,

To get total baseline work for a project, read the MSP_VIEW tables in
Project Server. See pjsrvr.htm in one of Project's program folders. When you
upgrade to PS 2007 you will need to re-create the SQL Server Views to read
from the 2007 reporting database, otherwise this method of reading direct
from SQL Server will let you upgrade to 2007 and it will still work (with
the updated view(s)).

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com