Where does PWA % work complete comes from?

P

pallavi333

We are creating project dashboard reports in SQL Reporting Services by
accessing the information from Project Server 2003 which holds data in
the SQL Server 2000 database. We need to know what table/field
contains the % Work Complete information for a project. This is the
same field exposed in the PWA entitled "% Work Complete". Can someone
help?
 
P

pallavi333

We are creating project dashboard reports in SQL Reporting Services by
accessing the information from Project Server 2003 its data is held in
the SQL Server 2000 database.  We need to know what table/field
contains the % Work Complete information for a project.  This is the
same field exposed in the PWA entitled "% Work Complete". Can someone
help?
Click to expand...


This is Pallavi again, i meant that the data is stored in SQL Server
2000.
 
C

Chak

This is Pallavi again, i meant that the data is stored in SQL Server
2000.
Click to expand...

Pallavi,

Run this SQL to view the Project names, start/finish dates and % work
complete:

***************************************************************
SELECT MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_START_DATE AS [Start
Dt], MSP_TASKS.TASK_FINISH_DATE AS [Finish Dt],
MSP_TASKS.TASK_PCT_COMP AS [% Complete]
FROM MSP_TASKS INNER JOIN
MSP_PROJECTS ON MSP_TASKS.PROJ_ID =
MSP_PROJECTS.PROJ_ID
WHERE (MSP_TASKS.TASK_ID = 0)
ORDER BY MSP_PROJECTS.PROJ_NAME

**************************************************************


Thanks
Chak
 
P

pallavi333

On Feb 15, 2:19 pm,[email protected] wrote:
Click to expand...
This isPallaviagain, i meant that the data is stored in SQL Server
2000.
Click to expand...

Pallavi,

Run this SQL to view the Project names, start/finish dates and % work
complete:

***************************************************************
SELECT     MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_START_DATE AS [Start
Dt], MSP_TASKS.TASK_FINISH_DATE AS [Finish Dt],
                      MSP_TASKS.TASK_PCT_COMP AS [% Complete]
FROM         MSP_TASKS INNER JOIN
                      MSP_PROJECTS ON MSP_TASKS.PROJ_ID =
MSP_PROJECTS.PROJ_ID
WHERE     (MSP_TASKS.TASK_ID = 0)
ORDER BY MSP_PROJECTS.PROJ_NAME

**************************************************************

Thanks
Chak
Click to expand...

Thank so much Chak.
 
Top