Call Logging Summary Report
true
Calls Logged For The Period [STARTDATE1] to [ENDDATE1]
SELECT Count(tbl_Calls.CallID) FROM tbl_Calls WHERE (tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')
AND tbl_Calls.QueueID = [PARAM1]
No. Of Calls Logged
Calls Closed For The Period [STARTDATE1] to [ENDDATE1] Prior To Due Date
SELECT Count(tbl_Calls.CallID) FROM tbl_Calls WHERE
(tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')
AND DATEDIFF(ss, tbl_Calls.Closed, tbl_Calls.DueDate) >= 0 AND tbl_Calls.QueueID = [PARAM1]
No. Of Calls Logged And Closed Prior To Due Date
Calls Closed For The Period [STARTDATE1] to [ENDDATE1] After Due Date
SELECT Count(tbl_Calls.CallID) FROM tbl_Calls WHERE
(tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')
AND (DATEDIFF(ss, tbl_Calls.DueDate, tbl_Calls.Closed) >= 0) AND tbl_Calls.QueueID = [PARAM1]
No. Of Calls Logged And Closed After Due Date
Calls Logged And Closed On The Same Day For The Period [STARTDATE1] to [ENDDATE1]
SELECT Count(tbl_Calls.CallID) FROM tbl_Calls WHERE
(tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')
AND (DATEDIFF(dd, tbl_Calls.Closed, tbl_Calls.DateEntered) >= 0) AND tbl_Calls.QueueID = [PARAM1]
No. Of Calls Logged And Closed On The Same Day
Calls Logged And Still Outstanding For The Period [STARTDATE1] to [ENDDATE1]
SELECT Count(tbl_Calls.CallID) FROM tbl_Calls WHERE
(tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')
AND tbl_Calls.CallStatusID IN (1,2,4,5,7) AND tbl_Calls.QueueID = [PARAM1]
No. Of Calls Logged And Still Outstanding
Calls Logged For Division \ Portfolio \ Business Unit For The Period [STARTDATE1] to [ENDDATE1]
true
SELECT COUNT(tbl_Calls.CallID), tbl_Calls.Division, tbl_Calls.Location, tbl_Calls.Department
FROM tbl_Calls WHERE (tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')
AND tbl_Calls.QueueID = [PARAM1]
GROUP BY tbl_Calls.Division, tbl_Calls.Location, tbl_Calls.Department
No. Of Calls Logged
Division
Portfolio
Department