Inflectra Customer Forums: Very simple traceability matrix - Requirement to Test case report (Thread)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 v 5.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 REQUIREMENT_ID REQUIREMENT_NAME TEST_CASE_ID TEST_CASE_NAME en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/1567.aspxthreadId=1567Dave F (david.furlani@federalgroup.com.au)reportingVery simple traceability matrix - Requirement to Test case reportThe 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 v 5.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 REQUIREMENT_ID REQUIREMENT_NAME TEST_CASE_ID TEST_CASE_NAME Sun, 13 Nov 2016 22:45:58 -05002018-08-16T06:58:32-04:00/Support/Forum/spirateam/reports/1567.aspxmessageId=2813David J (support1@inflectra.com) Thanks Dave! Thanks Dave! Mon, 14 Nov 2016 15:06:22 -05002016-11-14T15:06:22-05:00/Support/Forum/spirateam/reports/1567.aspx#reply2813messageId=3372Tung Nguyen (tran.nguyen@transport.nsw.gov.au) Hi, how can I get the Requirement Description instead of Name? And how can I append the test result Hi, how can I get the Requirement Description instead of Name? And how can I append the test results for the test run? Thank you Thu, 16 Aug 2018 06:58:32 -04002018-08-16T06:58:32-04:00/Support/Forum/spirateam/reports/1567.aspx#reply3372