Thread

Skip Navigation LinksForums > SpiraTeam Forums > Spira Custom Reports > Very simple traceability ...

Very simple traceability matrix - Requirement to Test case report RSS Feed

Sunday, November 13, 2016
The attached it useful for reporting on test case coverage.  I wanted this to be simple and clean.  I hope some of you find this useful.

Spira ver - SpiraTeam v5.0.0.8

Report sample
Requirement / Test Case Traceability Report    
REQUIREMENT_ID REQUIREMENT_NAME TEST_CASE_ID TEST_CASE_NAME
104 3.14 RG Reporting 2600 Reports can be accessed remotely and are filterable
104 3.14 RG Reporting 2601 VIP Room Access report
104 3.14 RG Reporting 2602 Player Status Report
104 3.14 RG Reporting 2603 Player Status Change History
104 3.14 RG Reporting 2604 RG Incidents by member
103 3.13 RG Management User Matrix 2605 WPH RG Manager/Staff, member home venue is WPH
103 3.13 RG Management User Matrix 2606 WPH RG Manager/Staff, member home venue is CCT
103 3.13 RG Management User Matrix 2607 CCT RG Manager/Staff, member home venue is CCT
103 3.13 RG Management User Matrix 2608 CCT RG Manager/Staff, member home venue is WPH

Query
select R.REQUIREMENT_ID, R.REQUIREMENT_NAME, R.TEST_CASE_ID, R.TEST_CASE_NAME from SpiraTestEntities. R_RequirementTestCases as R where R.PROJECT_ID = ${ProjectId}

Template
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
  <xsl:template match="/RESULTS">
    <table class="DataGrid">
 <tr>
  <th>REQUIREMENT_ID</th>
  <th>REQUIREMENT_NAME</th>
  <th>TEST_CASE_ID</th>
  <th>TEST_CASE_NAME</th></tr>
      <xsl:for-each select="ROW">
         <tr>
  <td><xsl:value-of select="REQUIREMENT_ID"/></td>
  <td><xsl:value-of select="REQUIREMENT_NAME"/></td>
  <td><xsl:value-of select="TEST_CASE_ID"/></td>
  <td><xsl:value-of select="TEST_CASE_NAME"/></td>
         </tr>
      </xsl:for-each>
      </table>
    </xsl:template>
</xsl:stylesheet>
1 Replies
Adam SAdam S
re: Dave F on Sunday, November 13, 2016
Monday, November 14, 2016
Thanks Dave!
Tagged
Statistics
  • Started: 11/13/2016
  • Last Reply: 11/14/2016
  • Replies: 1
  • Views: 81
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2017 | Licensed to Inflectra Corporation.