Vacant and Filled position report

Hi Experts,

We need a report that has all current vacant and filled positions on one report along with the supervisor of each position. 2nd e-mail from the user.

Do we have any standard report to cater to this requirement or we have to go for adhoc query.

Thanks

Avneet