サインイン
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Timesheet Line status is Initialized to Approved status in PS 2010

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

  • 2012年6月7日 22:06
     
     
    サインインして投票
    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
     

すべての返信

  • 2012年6月7日 22:29
     
     回答済み
    サインインして投票
    0

    Actually here is one answer to my question...

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

    end

    • 回答としてマーク Pelican Carl 2012年6月21日 17:54
    •