#90 Report suggestion - status by project

[Tom Vergote]

I think a report: bugs by status by project would be
very useful

something like
project: prj1
open bugs: 15
closed bugs: 56

I think that would provide a decent overview on the
status of some projects and their release readyness

[Corey Trager]

Logged In: YES
user_id=645778

You know, right, that you can create reports yourself? If
you are handy with SQL. Look at setup.sql at the lines
starting with "insert into reports".

In psuedo sql, something like
select project,
sum(case when status desc = "open" then 1 else 0 end) [open
bugs],
sum (case when status desc = "closed" then 1 else 0 end)
[closed bugs]
from bugs
inner join projects....
inner join statuses...
group by project

[Tom Vergote]

Logged In: YES
user_id=676271

i do, but i just thought this would be a nice one to include
as a default one