D
Doug
I have a difference between remaining work displaying in MS Project and the amount of remaining work when queried directly from the database. This difference is apparent in only a few records. MS Project displays the correct information in "Task Usage" view.
Detailed Information:
Due to MS Projects poor reporting, we use Crystal Reports to identify overdue tasks. Using MS's suggested SQL Statement I have identified 4 overdue tasks.
However, viewing those tasks in "Usage View" the "Remaining Work" column has 0.
Application Information:
Project 2002 Pro & Server
SQL Statement used:
--select--
PROJ_NAME as Project,
TASK_NAME as Task,
RES_NAME as Resource,
ASSN_WORK/60000 as Work_Assigned,
(ASSN_WORK/60000 - ASSN_REM_WORK/60000) as Work_Complete,
ASSN_REM_WORK/60000 as Work_Remaining,
ASSN_FINISH_DATE as Scheduled_Finish
from
MSP_WEB_PROJECTS p,
MSP_WEB_ASSIGNMENTS a,
MSP_WEB_RESOURCES r
where
a.ASSN_REM_WORK > 0
and DATEDIFF(day, a.ASSN_FINISH_DATE, @check_date) > @days_late
and a.WPROJ_ID = p.WPROJ_ID
and a.WRES_ID = r.WRES_ID
Detailed Information:
Due to MS Projects poor reporting, we use Crystal Reports to identify overdue tasks. Using MS's suggested SQL Statement I have identified 4 overdue tasks.
However, viewing those tasks in "Usage View" the "Remaining Work" column has 0.
Application Information:
Project 2002 Pro & Server
SQL Statement used:
--select--
PROJ_NAME as Project,
TASK_NAME as Task,
RES_NAME as Resource,
ASSN_WORK/60000 as Work_Assigned,
(ASSN_WORK/60000 - ASSN_REM_WORK/60000) as Work_Complete,
ASSN_REM_WORK/60000 as Work_Remaining,
ASSN_FINISH_DATE as Scheduled_Finish
from
MSP_WEB_PROJECTS p,
MSP_WEB_ASSIGNMENTS a,
MSP_WEB_RESOURCES r
where
a.ASSN_REM_WORK > 0
and DATEDIFF(day, a.ASSN_FINISH_DATE, @check_date) > @days_late
and a.WPROJ_ID = p.WPROJ_ID
and a.WRES_ID = r.WRES_ID