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.