Sign in
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
Timesheet Line status is Initialized to Approved status in PS 2010

Answered Timesheet Line status is Initialized to Approved status in PS 2010

  • Thursday, 7 June, 2012 10:06 PM
     
     
    Sign In to Vote
    0

    Hi Folks,

    I am writing a report to extract timesheet line item status.  My problem is that

    MSP_TimesheetLine.TimesheetLineStatus seems to be initialized to 1: Approved - Please confirm. If  I am right about this, the resulting report makes no sense to the user - the first state is 'Approved', and then we go to 'Pending Approval'.

    I need some sort of SQL CASE statement to hide this initial 'Approved' state.

    Carl
     

All Replies

  • Thursday, 7 June, 2012 10:29 PM
     
     Answered
    Sign In to Vote
    0

    Actually here is one answer to my question...

    [Line Item Status] = case TimesheetItemApprover.ResourceName when 'Unknown Resource' then '' else MSP_TimesheetLineStatus.Description

    end

    • Marked As Answer by Pelican Carl Thursday, 21 June, 2012 5:54 PM
    •