updated report query