Report using Project Server data

S

SeventhSense

Hi all,

Could someone please provide some directions for the following problem?

I have to create a report that shows in a 14 weeks window all the projects
and the resources. What would be the good way to read data from the Project
Server database? directly creating Stored procedures or is there any other
way to get such information (PDS etc). how do people retrieve data from
Project Server DB for reporting purposes. I have some data in the outline
codes also.

I am planning to use SQL server reporting services and it can talk to any
kind of data source (XML, other formats).

Thanks.
 
R

Rod Gill

Start by using SQL Server reporting services on the MSP_VIEW tables. They
are read only and good for reporting on published projects. See pjsrvrdb.htm
in one of project's program folders.

--

Rod Gill
Project MVP

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