Report of Incidents by Program

The following Entity SQL (ESQL) should be used in the Spira custom report writer:

select R.INCIDENT_ID, R.NAME as INCIDENT_NAME, R.PROJECT_NAME, R.INCIDENT_TYPE_NAME, R.INCIDENT_STATUS_NAME, R.PRIORITY_NAME
from SpiraTestEntities.R_Incidents as R
where R.PROJECT_GROUP_ID = ${ProjectGroupId}

Then click the 'Create Default Template' option to generate the following XSLT report template:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
  <xsl:template match="/RESULTS">
    <table class="DataGrid"><tr><th>Incident #</th><th>Incident Name</th><th>Product</th><th>Type</th><th>Status</th><th>Priority</th></tr>
      <xsl:for-each select="ROW">
        <tr><td><xsl:value-of select="INCIDENT_ID"/></td><td><xsl:value-of select="INCIDENT_NAME"/></td><td><xsl:value-of select="PROJECT_NAME"/></td><td><xsl:value-of select="INCIDENT_TYPE_NAME"/></td><td><xsl:value-of select="INCIDENT_STATUS_NAME"/></td><td><xsl:value-of select="PRIORITY_NAME"/></td>
        </tr>
      </xsl:for-each>
        </table>
    </xsl:template>
</xsl:stylesheet>

Viewing the Report

If you run this report in Excel or HTML format, it will generate the following output: