Creating a report from the database

[uott2know]

I'm looking to pull some data directly from the Project Server database
to display on an external website. I understand the process of
querying the DB server from an ASP page. I'm just a little lost on
where to find some of the information I need. I'm looking for the
following fields:

Project Name
Project Manager
Start Date
Finish Date
% Complete
One custom field yet to be determined

I can see that some of the data is stored in the MSP_Projects table
(Project Name, Start & Finish date). I don't see where the Project
Manager is stored, unless that is the Proj_Prop_Author field.

Where would I find the % complete for the project? I'm pretty sure I
can find the custom field once I know which one it is in a table like
MSP_Text_Fields.

Any help would be greatly appreciated. Thanks!!

 

[Rod Gill]

In the MSP_Tasks table, UID numbers of 0 (zero) represent project summary
tasks and therefore the rolled up value for the project.

--

Rod Gill
Project MVP

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

 

[Dale Howard [MVP]]

uott2know --

The WRES_ID field in the MSP_WEB_PROJECTS table contains the ID number of
the resource who is the Owner of the project. I believe that Owner is what
you mean by the "Manager" of the project. The ID number and resource name
are both found in the MSP_WEB_RESOURCES table. Hope this helps.

 

[ahelp]

% Complete looks to be the TSK_PCT_COMP field in the MSP_TASKS table. If your
Project Manager is not the Owner Dales refers to, are you using a custom
field?

 

[uott2know]

Thanks for the help, guys!! I went away on vacation for a few days
around the Thanksgiving holiday, so I haven't had a chance to work on
this yet, but I think you all have pointed me in the right direction.

I'll be sure to ask if I need some more clarification.

Thanks again!!