Open Case Action Status Report By Category true true false false false false false SELECT tbl_Calls.CallID, tbl_Calls.Subject, tbl_Groups.GroupName, tbl_Actions.ActionTitle, tbl_Actions.ActionDescription, tbl_Actions.AssignedToFirstName + ' ' + tbl_Actions.AssignedToLastName AS [Assigned To], tbl_Actions.DateCompleted, tbl_Actions.Resolution, tbl_ActionStatus.ActionStatus FROM tbl_ActionStatus RIGHT OUTER JOIN tbl_Actions ON tbl_ActionStatus.ActionStatusID = tbl_Actions.ActionStatusID LEFT OUTER JOIN tbl_Calls ON tbl_Actions.CallID = tbl_Calls.CallID LEFT OUTER JOIN tbl_Groups ON tbl_Calls.GroupID = tbl_Groups.GroupID WHERE tbl_Calls.CallStatusID IN (1, 2, 4, 5, 7) AND tbl_Calls.QueueID = [PARAM1] AND tbl_Calls.GroupID = [PARAM2] Case Number Case Name Category Action Name Details Assigned To Resolution Date Resolution Notes Status