Hi all, Until Infectra create something like a report script trading area, I suggest we use this post to share our custom report scripts. Please provide both: The query/script code in a format others can cut and paste into their Spira Test The version of SpiraTest you are running A sample report to show others the results that your script will produce (i.e. a sample that shows a hew rows of your report, or attach a file) en-US(C) Copyright 2006-2026 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/1561.aspxthreadId=1561Dave F (david.furlani@federalgroup.com.au)reporting Hi all, Until Infectra create something like a report script trading area, I suggest we use this post to share our custom report scripts. Please provide both: The query/script code in a format others can cut and paste into their Spira Test The version of SpiraTest you are running A sample report to show others the results that your script will produce (i.e. a sample that shows a hew rows of your report, or attach a file) Wed, 09 Nov 2016 06:50:01 -05002016-11-10T15:07:38-05:00/Support/Forum/spirateam/reports/1561.aspxmessageId=2799David J (adam.sandman+support@inflectra.com)Hi Dave Thanks for setting this up. We are happy to help make this easier. We could create a separate forum category just for reports so that people can post their scripts in that forum rather than being replies to this. Would that be helpful? Regards Adam Wed, 09 Nov 2016 15:36:30 -05002016-11-09T15:36:30-05:00/Support/Forum/spirateam/reports/1561.aspx#reply2799messageId=2800Dave F (david.furlani@federalgroup.com.au) Sure, so long as it's widely available and known. Whatever helps the community better extract useful information from the tools. Thanks Thu, 10 Nov 2016 03:00:23 -05002016-11-10T03:00:23-05:00/Support/Forum/spirateam/reports/1561.aspx#reply2800messageId=2801Dave F (david.furlani@federalgroup.com.au) Here's the first one for everyone. A basic, simple traceability matrix 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 Thu, 10 Nov 2016 03:54:53 -05002016-11-10T03:54:53-05:00/Support/Forum/spirateam/reports/1561.aspx#reply2801messageId=2802David J (adam.sandman+support@inflectra.com) I have moved this entire thread to the new Custom Reporting forum. Thu, 10 Nov 2016 15:07:38 -05002016-11-10T15:07:38-05:00/Support/Forum/spirateam/reports/1561.aspx#reply2802