Project Server 2003 Report – Task %age work Completed

In Project Server 2003 custom reporting % age work complete report is given below having columns

Project Name
Resource Name
Year
Month
%age work compelted [Task Work Completed]

Query

SELECT dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME, dbo.MSP_WEB_PROJECTS.PROJ_NAME,
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeWork / 60000 AS [Work], dbo.MSP_WEB_RESOURCES.RES_NAME,
YEAR(dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart) AS Year_,
MONTH(dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart) AS Month_, dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID,
dbo.MSP_TASKS.TASK_PCT_WORK_COMP
FROM dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY INNER JOIN
dbo.MSP_WEB_ASSIGNMENTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID AND
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID = dbo.MSP_WEB_ASSIGNMENTS.TASK_UID INNER JOIN
dbo.MSP_WEB_PROJECTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
dbo.MSP_WEB_RESOURCES ON dbo.MSP_WEB_ASSIGNMENTS.WRES_ID = dbo.MSP_WEB_RESOURCES.WRES_ID INNER JOIN
dbo.MSP_TASKS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.ProjectUniqueID = dbo.MSP_TASKS.PROJ_ID AND
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID = dbo.MSP_TASKS.TASK_UID INNER JOIN
dbo.MSP_VIEW_PROJ_PROJECTS_ENT ON
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_VIEW_PROJ_PROJECTS_ENT.WPROJ_ID

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: