Your best bet is a calendar report, which provides a filter specifically for that functionality. From the 'Advanced Item' menu, there's an option right in the middle for 'Time Off' that will pull in those records. Supports most standard 'User' type fields - by Manager, Team, Group etc.