assignments report query