locked
Project 2010 Task Status Field for Reporting RRS feed

  • Question

  • Project 2010 Professional has a default "Status" field associated with Tasks with the values of On Schedule, Future Task, Late, and Completed. Is this field available in the Report Database and/or one of the OLAP cubes?  I don't see to be able to find this field anywhere and we would like to report task status on this field.

    Jim Sipe


    Jim Sipe
    Thursday, September 1, 2011 6:38 PM

Answers

  • The built in field is not available in the reporting db.  Try using the following formula in a custom field

    Switch(

    [% Complete]=100,"Complete",
    (([% Complete]<100) And ([Finish]<Date())),"Overdue",
    (([Baseline Start]=ProjDateValue("NA")) Or ([Baseline Finish]=ProjDateValue("NA"))),"No BL",
    [Finish Variance]<=0,"Green",
    [Finish Variance]<=(ProjDateDiff([Project Start],[Project Finish])*0.1),"Yellow",
    [Finish Variance]>(ProjDateDiff([Project Start],[Project Finish])*0.1),"Red")

    You can read the article here.

    http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=27

    This will allow it to display in project pro and pwa.  Keep in mind that using complex formulas are resource intensive.  If you just want the data to show up in a sql or excel report, you can create a varient within excel or ssrs.

     

    Thursday, September 1, 2011 8:21 PM

All replies

  • The built in field is not available in the reporting db.  Try using the following formula in a custom field

    Switch(

    [% Complete]=100,"Complete",
    (([% Complete]<100) And ([Finish]<Date())),"Overdue",
    (([Baseline Start]=ProjDateValue("NA")) Or ([Baseline Finish]=ProjDateValue("NA"))),"No BL",
    [Finish Variance]<=0,"Green",
    [Finish Variance]<=(ProjDateDiff([Project Start],[Project Finish])*0.1),"Yellow",
    [Finish Variance]>(ProjDateDiff([Project Start],[Project Finish])*0.1),"Red")

    You can read the article here.

    http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=27

    This will allow it to display in project pro and pwa.  Keep in mind that using complex formulas are resource intensive.  If you just want the data to show up in a sql or excel report, you can create a varient within excel or ssrs.

     

    Thursday, September 1, 2011 8:21 PM
  • OK, thanks for the information.  I will give that formula a try.
    Jim Sipe
    Friday, September 2, 2011 2:29 PM
  • That formula is different from how Project calculates the 'Status' task field.

    From https://support.office.com/en-us/article/Status-task-field-769145ac-e052-45af-a847-e5ef15778bb1

    How Calculated    If the task is 100 percent complete, then Microsoft Office Project sets the Status field to Complete.

    If the task start date is greater than the status date, then the Status field contains Future Task. If timephased cumulative percent complete is spread to at least the day before the status date, then the Status field contains On Schedule. If the timephased cumulative percent complete does not reach midnight on the day before the status date, then the Status field contains Late.

    So, to duplicate this you can create a custom Task field in Project Server with a formula that =[Status]. That will put the new custom field into your reporting schema. It does bring back values of 1,2,3,4,5 that you will need to translate into the text values, but that should be easy using SWITCH or an IF statement.

    Wednesday, May 3, 2017 10:25 PM