Creating summary of current recruitment

Summary

Creating summary of current recruitment

Content

We need a report which shows all requisitions, the status they are at and then once a candidate is offered/has accepted the role we want to show that candidates name/start date etc against that requisition. I am struggling to work out a way to pull this in to report without showing all candidates. Is there an expression that could help with this?