Excel Report 2010 : Project Work multiplied by 4 RRS feed

  • Question

  • Hello,

    I created a new Excel Report based on the ProjectsAndAssignments template. I set the RBS as Report Filter, ProjectName as Row Labels. Values : ProjectWork.

    The Work values displayed in the Excel Report are 4 times or 30 times greater than the Work values calculated by Project Pro.

    Any idea?

    Friday, April 27, 2012 11:31 AM

All replies

  • Hi WLID1966--

    What is the Work unit you see in MS project? Does the existing report dispaly  the correct value or the extended new report which you created with ProjectsAndAssignments template dispalys wrong data?

    Thanks, Amit Khare |EPM Consultant| Blog:

    Monday, April 30, 2012 10:59 AM
  • Hi Amit,

    Work units are "Hours" in MS Project Pro.

    That's the new report which displays wrong data.


    Monday, April 30, 2012 11:49 AM
  • Could you provide the SQL query you're using within the ODC file?  That might
    help troubleshoot.

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky
    Monday, April 30, 2012 12:04 PM
  • Andrew,

    The SQL query is the standard one which comes with the ProjectsAndAssignments template. I did not change it.

    For each Project, the Sum of ProjectCost and the Sum of  ProjectWork are multiplied by the same value, generally an integer.

    For example: 22 and 22 for Project_A, 33 and 33 for project_B, 4 and 4 for Project_C...

    NB: Values in Project Pro are th right one, values in the Excel Report are false.


    Monday, April 30, 2012 6:57 PM