various enhancements to department reports