none
View Pending Approvals 2010 RRS feed

  • Question

  • I am trying to develop a report to view all pending approvals.  I have seen some posts about using MSP_TimesheetLine_UserViewCF  if you use timesheets.  We are not using timesheets/SEM, so my question is has any other method been found to find this data for non-timesheet projects?  Can business intelligence be used to pull a report of this data?

    Long Live America

    Thursday, August 23, 2012 12:31 PM

Answers

  • Can you try combination of below two sources from Project Server Reporting Database.

    dbo.MSP_Timesheetline

    dbo.MSP_Timesheetline_OlapView

    Building a report on top of above sources should give you what you want.


    Abhijeet M. Mohite

    Thursday, August 23, 2012 2:42 PM

All replies

  • Can you try combination of below two sources from Project Server Reporting Database.

    dbo.MSP_Timesheetline

    dbo.MSP_Timesheetline_OlapView

    Building a report on top of above sources should give you what you want.


    Abhijeet M. Mohite

    Thursday, August 23, 2012 2:42 PM
  • Values for Timesheet Status can be interpreted as below:

    InProgress=0, Submitted=1, Acceptable=2, Approved=3, and Rejected=4.


    Abhijeet M. Mohite

    Thursday, August 23, 2012 2:44 PM
  • Abhijeet,

    Is "dbo.MSP_Timesheetline" going to work if we dont use timesheets on this project?


    Long Live America

    Thursday, August 23, 2012 8:53 PM