I have broken out your SQL Query into two statements. These will will go into separate Command Objects then be linked (joined) in the CR database expert.

The logic is that the first command object counts the callid to see if it is assigned to more that one person. If returns data only if it is assigned to 1 person and is closed. The second command object returns the details for the specific call id . If all is working correctly it should return information on those calls handled and cloed by one person.

 

Command Object 1

Select asgnmnt.callid, count(asgnmnt.callid) as countId
from asgnmnt
Left outer Join CallLog on asgnmnt.callid = calllog.callid
where callLog.callstatus = 'closed'
Group by asgnmnt.callid
Having count(asgnmnt.callid) = 1

 

Command Object 2
SELECT
CallLog.CallID as CallLogId,
CallLog.CloseDate,
CallLog.RecvdDate,
CallLog.CallType,
CallLog.CallStatus,
CallLog.Priority,
Asgnmnt.DateResolv
FROM CallLog
LEFT OUTER JOIN Asgnmnt
ON Asgnmnt.CallID = CallLog.CallID
where calllog.callstatus = 'closed'

You will need to link the two in the Database expert (Linking tab).
Likne the asgnmnt.callid in cmd Object1 to calllogId in Cmd Object 2

Since I dont have enough data you may need to try different joins.

 

This is about as much as I do for you at this point. I hope it helps.

 

Regards,

 

John W.