I need to display metrics from Mercury Quality Center 9.0 with a MS SQL database in an ASP or JSP page. Metrics must be displayed graphically in a chart, preferably a bar or pie chart.
Important!!!
I can not provide access to a Quality Center DB, or provide connection strings, etc, so you MUST have access to your own and I will modify connection params myself. The tables will be the same as long as you are using QC 9.0.
Page must allow user to choose project, then display data.
Data needed is as follows:
Number of tests in current project & iteration broken down by status (no run, pass, fail, blocked)
Number of current defects by project with a severity status of 1 or 2 displayed as open or resolved
All defects (all severities) by project that are open or resolved
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP or JSP. Either is fine. Must work in IE6.0 and above.