Inflectra Customer Forums: Need help creating a custom report (Thread) Hi. I have been trying to create a custom report for the last several days and am having some issues finishing it. I want a report that allows me to see all instances of a certain type of incident(we call these incidents Epics), along with all of its associated incidents of two certain types(we call them features and deliverables). We dont necessarily need any data along with the Epics themselves other than the name and number of the incident, along with the associations of course. We would like a table for the associations to have the columns for incident type, incident ID, incident name, status, estimated effort, remaining effort, actual effort, and owner. I have created a mockup of what I want the report to look like: The ability to filter certain fields before the report generates would be great if possible(especially helpful for detected release), similar to the way standard reports are now. If you could help provide some insight or code to help create this report, it would be much appreciated. 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/1985.aspxthreadId=1985Lukas Schumaker (lukas.schumaker@etegent.com)Need help creating a custom report Hi. I have been trying to create a custom report for the last several days and am having some issues finishing it. I want a report that allows me to see all instances of a certain type of incident(we call these incidents Epics), along with all of its associated incidents of two certain types(we call them features and deliverables). We dont necessarily need any data along with the Epics themselves other than the name and number of the incident, along with the associations of course. We would like a table for the associations to have the columns for incident type, incident ID, incident name, status, estimated effort, remaining effort, actual effort, and owner. I have created a mockup of what I want the report to look like: The ability to filter certain fields before the report generates would be great if possible(especially helpful for detected release), similar to the way standard reports are now. If you could help provide some insight or code to help create this report, it would be much appreciated. Fri, 08 Feb 2019 20:18:30 -05002019-02-12T01:04:24-05:00/Support/Forum/spirateam/reports/1985.aspxmessageId=3524Lukas Schumaker (lukas.schumaker@etegent.com) https://ibb.co/8mb3nCT This is a link to the mockup picture. Not quite sure if it can be seen in https://ibb.co/8mb3nCT This is a link to the mockup picture. Not quite sure if it can be seen in my original post. Fri, 08 Feb 2019 20:19:52 -05002019-02-08T20:19:52-05:00/Support/Forum/spirateam/reports/1985.aspx#reply3524messageId=3525David J (support1@inflectra.com) For the ESQL it is generally best to start with one of the built in queries. These will give you a For the ESQL it is generally best to start with one of the built in queries. These will give you a good guide on what data is available. There are dedicated tables in the database for ESQL purposes and they should be used in these built in queries. We do also have some example custom reports on our KB pages: https://www.inflectra.com/Support/KnowledgeBase/spira-reports/List.aspx these may give you some further insights, though none of the ones there are exactly what you are after. From my understanding of what you are trying to achieve, the built in incident detailed report will give you more information than you need, but is along the right lines. Now this does not export into excel, but it may be that filtering that report, and making sure to list linked incidents in it will give you what you need. If nothing else it could be a good starting point for your own report. Tue, 12 Feb 2019 01:04:23 -05002019-02-12T01:04:23-05:00/Support/Forum/spirateam/reports/1985.aspx#reply3525