MPP-Task Usage view RRS feed

  • Question

  • Hi,

    I'm trying to create a SSRS report in PWA site for display a data which is similar to Task Usage view in MPP .I manage to get the data of Work ,Acctual work cum work using the followin query. My question is how to get the valued of work (Project Progress ) ,Actual .Work (Project Progess) of the task usage field .

          sum([AssignmentWork]) as [AssignmentWork]
         ,sum([AssignmentActualWork])as [ActualWork]    
         ,MONTH(TimeByDay) AS [Month]
         ,YEAR(TimeByDay) AS [year]
    FROM MSP_EpmAssignmentByDay] 
    GROUP BY MONTH(TimeByDay),YEAR(TimeByDay),[ProjectUID]

    Monday, March 25, 2013 7:36 AM