none
Unsubmitted Timesheet Report (MSPS 2010) RRS feed

  • Question

  • Does the functionality exist within MSPS-PWA to to draw a report from that shows unsubmitted resource timesheets from past periods?    If not, what is the best practice employed to determine who has outstanding (unsubmitted) timesheets

    Thanks!

    ~RK

    Monday, December 3, 2012 8:19 PM

All replies

  • Hi,

    SELECT * FROM MSP_TIMESHEETS where TS_CACHED_RES_NAME = 'user1'

    The column “TS_STATUS_ENUM” value indicates the status of the timesheet.

    -- 0 - IN PROGRESS

    -- 3 - APPROVED

    -- 1 - Submitted

    -- 4 - Rejected

    Tuesday, December 4, 2012 3:50 AM
  • Hi RK--

    Yes, You can design SSRS report with the below query:
    http://gallery.technet.microsoft.com/projectserver/Server-20072010-SQL-Get-f1252098

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, December 4, 2012 4:41 AM
  • Hi Randy,

    There is a timesheet compliance report in the EPM report pack 2 for PS 2007 but you can re-use them for 2010. You might have to customise it slightly.

    Check the URL below:

    http://blogs.msdn.com/b/project_programmability/archive/2009/08/20/project-server-2007-report-pack-ii-the-top-reports.aspx


    Regards, Naweed

    Tuesday, December 4, 2012 4:05 PM