Have a play with this.
Create the Report Definition as Anonymous Block with @UserName as a string.
You could create a value list for all Agents to make it easier for them to select their username on the filters.
SELECT
Queue = Variable3,
DateTime,
Agent.EnterpriseName as Agent,
Skill_Group.EnterpriseName as SkillGroup,
CASE TCD.CallDisposition
WHEN 1 THEN 'Abandoned in Network'
WHEN 2 THEN 'Abandoned in Local Queue'
WHEN 3 THEN 'Abandoned Ring'
WHEN 4 THEN 'Abandoned Delay'
WHEN 5 THEN 'Abandoned Interflow'
WHEN 6 THEN 'Abandoned Agent Terminal'
WHEN 7 THEN 'Short'
WHEN 8 THEN 'Busy'
WHEN 9 THEN 'Forced Busy'
WHEN 10 THEN 'Disconnect / Drop No Answer'
WHEN 11 THEN 'Disconnect / Drop Busy'
WHEN 12 THEN 'Disconnect / Drop Reorder'
WHEN 13 THEN 'Disconnect / Drop Handled Primary Route'
WHEN 14 THEN 'Disconnect / Drop Handled Other'
WHEN 15 THEN 'Redirected'
WHEN 16 THEN 'Cut Through'
WHEN 17 THEN 'Intraflow'
WHEN 18 THEN 'Interflow'
WHEN 19 THEN 'Ring No Answer'
WHEN 20 THEN 'Intercept Reorder'
WHEN 21 THEN 'Intercept Denial'
WHEN 22 THEN 'Time Out'
WHEN 23 THEN 'Voice Energy'
WHEN 24 THEN 'Non-Classified Energy Detected'
WHEN 25 THEN 'No Cut Through'
WHEN 26 THEN 'U-Abort'
WHEN 27 THEN 'Failed Software'
WHEN 28 THEN 'Blind Transfer'
WHEN 29 THEN 'Announced Transfer'
WHEN 30 THEN 'Conferenced'
WHEN 31 THEN 'Duplicate Transfer'
WHEN 32 THEN 'Unmonitored Device'
WHEN 33 THEN 'Answering Machine'
WHEN 34 THEN 'Network Blind Transfer'
WHEN 35 THEN 'Task Abandoned in Router'
WHEN 36 THEN 'Task Abandoned Before Offered'
WHEN 37 THEN 'Task Abandoned While Offered'
WHEN 38 THEN 'Normal Task End'
WHEN 39 THEN 'Cant Obtain Task ID'
WHEN 40 THEN 'Agent Logged Out During Task'
WHEN 41 THEN 'Maximum Task Lifetime Exceeded'
WHEN 42 THEN 'Application Path Went Down'
WHEN 51 THEN 'Task Ended During Application Init'
WHEN 53 THEN 'Partial Call'
ELSE 'Unknown'
END as CallDisposition,
TCD.DigitsDialed,
TCD.DNIS,
TCD.ANI,
TCD.TalkTime,
TCD.RingTime,
TCD.TimeToAband,
TCD.Duration,
TCD.HoldTime,
TCD.LocalQTime,
TCD.WorkTime,
CASE TCD.CallDispositionFlag
WHEN 1 THEN 'Handled'
WHEN 2 THEN 'Abandoned'
WHEN 3 THEN 'Short'
WHEN 4 THEN 'Disconnect'
WHEN 5 THEN 'Redirected'
WHEN 6 THEN 'Requery'
WHEN 7 THEN 'Incomplete'
ELSE 'Unknown'
END as CallDispositionFlag,
Agent.SkillTargetID
FROM
Termination_Call_Detail TCD JOIN
Agent ON TCD.AgentSkillTargetID = Agent.SkillTargetID JOIN
Skill_Group ON TCD.SkillGroupSkillTargetID = Skill_Group.SkillTargetID
WHERE Agent.EnterpriseName = :UserName
AND DateTime >= :startDate
AND DateTime <= :endDate
ORDER BY
Agent.EnterpriseName ASC,
DateTime ASC
