added all to department and locations in reports