Hello,

I have been trying to combine two of your default reports, "Defects Found by Week" and "Defects Fixed by Week" into one report basically.  I would like to have a report generate two line graphs, one plotting the defects opened and the other plotting defects fixed listed by week.

Could you please direct me on how to create this report.  I have tried using the report chart wizard, but do not know the SQL to enter to get it to pull the data necessary.  I tried editing the default reports and combining them into one, also with no success.

 Any help would very much be appreciated.

 Thanks!
 

The only way that you can have a report that would give you both defects and features together would be to create a custom report via SQL statements in the OnTime application. Below is an example of a custom SQL report that has combined defects, features, tasks and incidents into one single report.

Thank you,

I've done a similar thing to what Dragan suggested, but created a view in the OnTime database, then I have about a dozen different reports based on that view. The view joins to all the status and priority tables etc, and like Dragan's incorporates all the types of items.

I would attach it, except it relies on about 6 custom fields so it is unlikely to help much more than what has already been provided.