Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Excel Report 2010 : Project Work multiplied by 4

Domanda Excel Report 2010 : Project Work multiplied by 4

  • Friday, 27 April 2012 11:31 AM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Monday, 30 April 2012 10:59 AM
     
     
    Sign In to Vote
    0

    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: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

     
  • Monday, 30 April 2012 11:49 AM
     
     
    Sign In to Vote
    0

    Hi Amit,

    Work units are "Hours" in MS Project Pro.

    That's the new report which displays wrong data.

    Thanks

     
  • Monday, 30 April 2012 12:04 PM
    Moderator
     
     
    Sign In to Vote
    0
    Could you provide the SQL query you're using within the ODC file?  That might
    help troubleshoot.
     
     
    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
     
  • Monday, 30 April 2012 6:57 PM
     
     
    Sign In to Vote
    0

    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.