Inflectra Customer Forums: Test execution status per Release with Actual result (Thread)This report allows me to use Excel to draw a lot of information from the testing performed over multiple releases to see how we are tracking, find recurring issues, produce stats on the defects causing the largest impact to testing, etc. Ver 5.0.0.8 Report sample: Release Test Case ID Test Case Name Status Date Executed Actual Result R7 - 20 Sept 3112 Upload documents - allowable formats Blocked 20/09/2016 Known environmental issue. Server being rebuilt R8 - 3 Oct 3112 Upload documents - allowable formats Failed 4/10/2016 317 R9 - 12 Oct 3112 Upload documents - allowable formats Passed 12/10/2016 R7 - 20 Sept 3115 Search functionality Passed 20/09/2016 R8 - 3 Oct 3115 Search functionality Failed 4/10/2016 322 R9 - 12 Oct 3115 Search functionality Not Run -- R10 - 24 Oct 3115 Search functionality Passed 26/10/2016 R11 - 7 Nov 3115 Search functionality Passed 9/11/2016 Query: select R.TEST_CASE_ID, R.TEST_CASE_NAME, R.EXECUTION_STATUS_NAME, R.ACTUAL_RESULT, R.END_DATE, L.RELEASE_NAME from SpiraTestEntities.R_TestRunSteps as R LEFT JOIN SpiraTestEntities.R_TestRuns AS L ON R.TEST_RUN_ID=L.TEST_RUN_ID AND R.PROJECT_ID = ${ProjectId} Template: Release Test Case ID Test Case Name Status Date Executed Actual Result 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/1569.aspxthreadId=1569Dave F (david.furlani@federalgroup.com.au)reportingTest execution status per Release with Actual resultThis report allows me to use Excel to draw a lot of information from the testing performed over multiple releases to see how we are tracking, find recurring issues, produce stats on the defects causing the largest impact to testing, etc. Ver 5.0.0.8 Report sample: Release Test Case ID Test Case Name Status Date Executed Actual Result R7 - 20 Sept 3112 Upload documents - allowable formats Blocked 20/09/2016 Known environmental issue. Server being rebuilt R8 - 3 Oct 3112 Upload documents - allowable formats Failed 4/10/2016 317 R9 - 12 Oct 3112 Upload documents - allowable formats Passed 12/10/2016 R7 - 20 Sept 3115 Search functionality Passed 20/09/2016 R8 - 3 Oct 3115 Search functionality Failed 4/10/2016 322 R9 - 12 Oct 3115 Search functionality Not Run -- R10 - 24 Oct 3115 Search functionality Passed 26/10/2016 R11 - 7 Nov 3115 Search functionality Passed 9/11/2016 Query: select R.TEST_CASE_ID, R.TEST_CASE_NAME, R.EXECUTION_STATUS_NAME, R.ACTUAL_RESULT, R.END_DATE, L.RELEASE_NAME from SpiraTestEntities.R_TestRunSteps as R LEFT JOIN SpiraTestEntities.R_TestRuns AS L ON R.TEST_RUN_ID=L.TEST_RUN_ID AND R.PROJECT_ID = ${ProjectId} Template: Release Test Case ID Test Case Name Status Date Executed Actual Result Mon, 14 Nov 2016 00:12:53 -05002023-11-03T17:26:37-04:00/Support/Forum/spirateam/reports/1569.aspxmessageId=2815David J (support1@inflectra.com) Thanks Dave. Thanks Dave. Mon, 14 Nov 2016 15:09:06 -05002016-11-14T15:09:06-05:00/Support/Forum/spirateam/reports/1569.aspx#reply2815