missing work values

[JAnderson]

Hi there,
I'm beginning to use Crystal XI to pull enterprise wide reports from our MS
Project Server 2003 system. Any reports I try to pull for Actual Work values
(I'm using MSP_Web_Work WWork_Type=1) will not report any work that is a
duplicate value of the same task on the second day.

For example, if Fred Jones reports 2 hrs on Monday on task "Compile Comps
Report" and 2 hrs again on Tuesday for the same task and 2 hrs again on the
same task on Thursday, the report will only pull the 2 hrs for Monday and the
2 hrs for Thursday. I've verified through PWA-Adjust Actuals that the time is
in there, but can't get it to pull out.

Can anyone help point me in the right direction? It would be greatly
appreciated.

Here is the query that Crystal helped build for me
SELECT "MSP_WEB_RESOURCES"."RES_NAME", "MSP_WEB_ASSIGNMENTS"."TASK_NAME",
"MSP_WEB_WORK"."WWORK_VALUE", "MSP_WEB_PROJECTS"."PROJ_NAME",
"MSP_WEB_WORK"."WWORK_START", "MSP_WEB_WORK"."WWORK_TYPE",
"MSP_WEB_WORK"."WASSN_ID"
FROM (("ProjectServer"."dbo"."MSP_WEB_ASSIGNMENTS" "MSP_WEB_ASSIGNMENTS"
INNER JOIN "ProjectServer"."dbo"."MSP_WEB_PROJECTS" "MSP_WEB_PROJECTS" ON
"MSP_WEB_ASSIGNMENTS"."WPROJ_ID"="MSP_WEB_PROJECTS"."WPROJ_ID") INNER JOIN
"ProjectServer"."dbo"."MSP_WEB_RESOURCES" "MSP_WEB_RESOURCES" ON
"MSP_WEB_ASSIGNMENTS"."WRES_ID"="MSP_WEB_RESOURCES"."WRES_ID") INNER JOIN
"ProjectServer"."dbo"."MSP_WEB_WORK" "MSP_WEB_WORK" ON
"MSP_WEB_ASSIGNMENTS"."WASSN_ID"="MSP_WEB_WORK"."WASSN_ID"
WHERE "MSP_WEB_WORK"."WWORK_TYPE"=1 AND
"MSP_WEB_PROJECTS"."PROJ_NAME"=N'2008 Pohly General Overhead'
ORDER BY "MSP_WEB_RESOURCES"."RES_NAME", "MSP_WEB_WORK"."WWORK_START"

Thanks in advance for your valuable help,
Jennifer

 

[Rod Gill]

I would use the MSP_VIEW tables. They include normalized values for
timephased data. When you upgrade to Project Server 2007+ then replace the
MSP_VIEW tables with tables and views from 2007's reporting database.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com