Se connecter
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Timesheet Line status is Initialized to Approved status in PS 2010

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

  • jeudi 7 juin 2012 22:06
     
     
    Connectez-vous pour voter
    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
     

Toutes les réponses

  • jeudi 7 juin 2012 22:29
     
     Traitée
    Connectez-vous pour voter
    0

    Actually here is one answer to my question...

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

    end

    • Marqué comme réponse Pelican Carl jeudi 21 juin 2012 17:54
    •