Quality Center Report

Question ID: 104443
0
0

I’m looking to generate a report in QC 10 that will show weekly test execution from Test Lab. What is the best way to go about it?

Marked as spam
Posted by (Questions: 1, Answers: 1)
Asked on January 12, 2012 4:25 pm
7 views
Answers (2)
1
Private answer

Have you looked into using the Excel reports under the Dashboard? You first create a SQL query to gather the data from the QC database, then you can manipulate the data and how it is displayed in Excel. Don't forget you can use parameters in the query to delineate timeframes, etc if needed.

Marked as spam
Posted by (Questions: 2, Answers: 3)
Answered on January 13, 2012 9:23 am
1
Private answer

You can also use the Graph Wizard in the Dashboard if you want to create a graph to illustrate your results. You can narrow the data you want displayed by using the Filters and Cross Filters. If you are planning to create a chart in Excel you will need to use some basic SQL to create your chart. If you need some practice with SQL (http://www.sqlcourse.com/index.html) this is a great site for learning and practicing. Here is a simple graph that I use I one of my projects.

select b.tc_test_id, c.TS_NAME, c.TS_USER_04, b.TC_STATUS from cycle a, testcycl b, test c
where b.tc_cycle_id = a.cy_cycle_id and b.tc_test_id = c.ts_test_id
and a.cy_cycle ='January 2012'

TC_TEST_ID TS_NAME TS_USER_04 TC_STATUS
3508 Tech Console - 4 button functionality NA Passed
3908 CB - Dispositions show for account numbers with less than 9 char HLP000001225626 Passed
3909 CB - Dispositions show for account numbers with 9 char HLP000001225626 Passed
3949 User-Group Control Center - Clone user as admin IM0000000011214 Passed
3950 HLP - Users that are not in group will not show in assigned to IM0000000011214 Passed
3951 HLP - Modify All contains values in Resolutions HLP000001347756 Passed
3952 HLP - Modify All - Resolve ticket HLP000001347756 Passed
3953 HLP - Modify All - Resolve Multiple tickets HLP000001347756 Passed
3954 ADM_Groups - Display correct Group ID IM0000000011291 Passed
3955 ADM_Groups - Group Request Id matches New Group Passed
3957 QST_questionTemplates HLP000001244438 Passed
3962 HLP Ticket - Automated IT Customer Satisfaction Survey Functionality IM0000000009511 Failed
3963 MNT - Notification sent for State Change IM0000000011334 Passed

Marked as spam
Posted by (Questions: 0, Answers: 1)
Answered on January 13, 2012 11:21 am