none
Resume field for reporting from Project Server 2010 RRS feed

  • Question

  • We're using Project Server 2010.  We have a custom view in Project Pro that uses the Resume field to filter tasks that have incomplete work in the past.  I want to create a similar report but can't locate the Resume field in any of tables or views.  Does anyone know a) where this field is located and b) a reference for the schema for report developers for Project Server 2010?
    Walter
    Tuesday, November 29, 2011 5:22 PM

Answers

  • Hi Walter,

    I don't think the default Resume field is in the Reporting database. The only option I can think of is to create a new Task Level custom field that uses a formula, set the forumla to [Resume]. Open up Project Professional and publish the Projects so that the Resume date is pushed through to the Reporting database, you will see this value in the new Task Level custom field in the MSP_EpmTask_UserView.

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Marked as answer by wacNTN Tuesday, November 29, 2011 6:41 PM
    Tuesday, November 29, 2011 5:50 PM
    Moderator

All replies

  • Hi Walter,

    I don't think the default Resume field is in the Reporting database. The only option I can think of is to create a new Task Level custom field that uses a formula, set the forumla to [Resume]. Open up Project Professional and publish the Projects so that the Resume date is pushed through to the Reporting database, you will see this value in the new Task Level custom field in the MSP_EpmTask_UserView.

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Marked as answer by wacNTN Tuesday, November 29, 2011 6:41 PM
    Tuesday, November 29, 2011 5:50 PM
    Moderator
  • Thanks for the info.  I'll go that route. 
    Walter
    Tuesday, November 29, 2011 6:41 PM