Improve summary Project queries

We need better statistics on defects and new features by projects. Your project query today only displays status by priority. We need to see quantities of defects by state. Attached is our weekly status report. PLease see below:

Feature/Defect Deliverables Who Total UA 20% 40% 60% Done
SMH Feature/Defects Rich 41 39 0 0 2 2
Eagle Feature/Defects Thuyen 123 0 20 20 24 79
AMMO Reported defects Josh 658 (630) 14 52
(72) 108
(158) 133
(75) 351 (325)
AMMO New Features Josh 151 15 27 63 21 24

Legend
UA UnAssigned Done Closed
20% Requirements clarification (XX) Prior Week
40% Assigned to development
60% Resolved
Progress

The statues we use are unassigned, assigned, resolved, closed. We report weekly a breakdown between bug and new feature. Also we want to compare this weeks results to last weeks results. I can send you the report in WORD if you give me an e-mail. To do this report I have to execute about 20 queries. rich