Reporting with HP ALM - Quality Center 11.0 (2677 Views)
Reply
Frequent Advisor
rastek1
Posts: 91
Registered: ‎09-26-2011
Message 1 of 4 (2,677 Views)
Accepted Solution

Reporting with HP ALM - Quality Center 11.0

Hi All, I just took a positon in the testing team using this tool. The team has a general reporting problem. What they want to see is: See a project's all -> Cyles -> test sets -> scripts from one report. I mean, cycles, under test sets, under scripts, and shows which tests and scripts ran properly, what percentage of the tests ran properly, etc. They have told from HP support that QC does not support this as default. A developer told me that QC test database tables are not related et all. When we generated diagrams within the MSSQL,  there is no connection between the tables??We couldnt see any arrows.. 

 

(Before that I was working with VS testing, and In Visual Studio Testing, tables were related..),

 

Since HP QC is far more professional, I think HP QC must handle this in some way. Any Idea about this ?

 

By the way, I have read brochure of a tool called "Assure Project Harmonizer" for HP QC 10.0 . I am not sure whether this tool can help us on reoprting. Another thing is that right now we are using HP ALM - Quality Center 11.0, maybe some properties also added in version 11.0

 

Please somebody help me on this, thanks. Best Regards.

Esteemed Contributor
William Schmitt
Posts: 342
Registered: ‎04-02-2008
Message 2 of 4 (2,660 Views)

Re: Reporting with HP ALM - Quality Center 11.0

QC database tables are relational but there are no relations established by default.  It is possible to create queries that join the proper tables to do the kind if reporting that you want.  The query builder in the report module will help you create the SQL queries that you need to do this.

Occasional Visitor
Viswa007
Posts: 1
Registered: ‎12-13-2011
Message 3 of 4 (2,561 Views)

Re: Reporting with HP ALM - Quality Center 11.0

Hi All,

 

Can any one please help me. I want to create report with defect id and number of scripts blocked because of that defect.

 

Report should be like this.

 

Defect Id     Number of scripts blocked

 

333                7

544                9

 

I have created query but its not working properly. Can any one please correct my query.

 

SELECT BUG.BG_BUG_ID, count(TEST.TS_NAME)
FROM  BUG,TEST
where BUG.BG_STATUS in ('New','Open')
and  TEST.TS_STATUS='Blocked'
and  BUG.BG_TEST_REFERENCE= TEST.TS_TEST_ID
group by BUG.BG_BUG_ID

Honored Contributor
Trudy Claspill
Posts: 3,779
Registered: ‎09-09-2010
Message 4 of 4 (2,549 Views)

Re: Reporting with HP ALM - Quality Center 11.0

Viswa007,

 

You should start a new thread for this question.  Your question doesn't is not really on the same topic (yours is much more specific).  Hijacking a solved thread with a new question off topic is generally bad forum etiquette.  Also people are less likely to look at a Solved post when looking for posts that still have unanswered questions. :-)

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.