Seems to me you need to play around with subreports and passing parameters to these subreports so that you only get information for one agent.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP