Inflectra Customer Forums: Custom Report or Graph with Test Cases by Program (Thread) Hi, I am trying to find a way to show All test cases by Project and Status. I looked in the the build in Reports, but I couldnt find. I tried creating custom one, but I ended up by select INC.PROJECT_NAME, count(INC.TEST_CASE_ID) as INCIDENT_COUNT from SpiraTestEntities.R_TestCases as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME order by INC.PROJECT_NAME I want to be able to show the table below in a report or graph. Can anyone help please. Test Case Status 1 Test Case Status 2 Test Case Status 3 Project 1 Project 2 Project 3 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/2114.aspxthreadId=2114Plamen Sakutov (plamen.sakutov@strypes.eu)report graph custom test casesCustom Report or Graph with Test Cases by Program Hi, I am trying to find a way to show All test cases by Project and Status. I looked in the the build in Reports, but I couldnt find. I tried creating custom one, but I ended up by select INC.PROJECT_NAME, count(INC.TEST_CASE_ID) as INCIDENT_COUNT from SpiraTestEntities.R_TestCases as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME order by INC.PROJECT_NAME I want to be able to show the table below in a report or graph. Can anyone help please. Test Case Status 1 Test Case Status 2 Test Case Status 3 Project 1 Project 2 Project 3 Thu, 21 Nov 2019 09:46:26 -05002019-11-26T22:22:54-05:00/Support/Forum/spirateam/reports/2114.aspxmessageId=3690David J (adam.sandman+support@inflectra.com) Hi Plamen, You need to use something like this: select INC.PROJECT_NAME, sum(case when Hi Plamen, You need to use something like this: select INC.PROJECT_NAME, sum(case when INC.EXECUTION_STATUS_NAME = 'Passed' then 1 else 0 end) as PASS_COUNT, sum(case when INC.EXECUTION_STATUS_NAME = 'Failed' then 1 else 0 end) as FAIL_COUNT, sum(case when INC.EXECUTION_STATUS_NAME = 'Not Run' then 1 else 0 end) as NOT_RUN_COUNT from SpiraTestEntities.R_TestCases as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME order by INC.PROJECT_NAME Regards David Tue, 26 Nov 2019 22:22:54 -05002019-11-26T22:22:54-05:00/Support/Forum/spirateam/reports/2114.aspx#reply3690