Hi I would like to create report which will looks like that Component name Covering Passed Failed Blocked In Progress Book Management 17 8 3 0 20% Author Management 3 2 0 1 50% Administration 1 1 0 0 10% all Requirements are split out into 10 Components (parents requirement) to have better overview of status of each component, and I need to know what is the Requirement coverage total in each component + progress. in code I have only overview of each Coverage name in separate column... else, need help here Component Name Priority Status Covering Passed Failed Blocked Task %On Schedule %Running Late %Starting Late %Not Started padding-left: px; 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/1896.aspxthreadId=1896Aleksandra Marszalek (ama@avito.no) Hi I would like to create report which will looks like that Component name Covering Passed Failed Blocked In Progress Book Management 17 8 3 0 20% Author Management 3 2 0 1 50% Administration 1 1 0 0 10% all Requirements are split out into 10 Components (parents requirement) to have better overview of status of each component, and I need to know what is the Requirement coverage total in each component + progress. in code I have only overview of each Coverage name in separate column... else, need help here Component Name Priority Status Covering Passed Failed Blocked Task %On Schedule %Running Late %Starting Late %Not Started padding-left: px; Fri, 10 Aug 2018 09:19:20 -04002018-08-10T12:55:19-04:00/Support/Forum/spirateam/reports/1896.aspxmessageId=3367Aleksandra Marszalek (ama@avito.no) COMPONENT_NAME Covering Passed Failed 42 21 6 Administration 0 0 0 Author Management 14 7 2 Book Management 30 15 4 select R.COMPONENT_NAME,sum(R.COVERAGE_COUNT_TOTAL) as Covering, sum(R.COVERAGE_COUNT_PASSED) as Passed, sum(R.COVERAGE_COUNT_FAILED) as Failed from SpiraTestEntities.R_Requirements as R where R.PROJECT_ID = ${ProjectId} group by R.COMPONENT_NAME COMPONENT_NAME Covering Passed Failed Fri, 10 Aug 2018 12:55:19 -04002018-08-10T12:55:19-04:00/Support/Forum/spirateam/reports/1896.aspx#reply3367