Report Displaying Projects, Project Groups and Releases

Here's the Entity SQL you need to use to get that data:

select P.PROJECT_ID, P.NAME, P.PROJECT_GROUP_ID, P.PROJECT_GROUP_NAME, R.RELEASE_ID, R.NAME as RELEASE_NAME, R.RELEASE_STATUS_NAME from SpiraTestEntities.R_Projects as P
join SpiraTestEntities.R_Releases as R on R.PROJECT_ID = P.PROJECT_ID

and here's the XSLT template to put that into a nice grid:

<?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>PROJECT_ID</th><th>NAME</th><th>PROJECT_GROUP_ID</th><th>PROJECT_GROUP_NAME</th><th>RELEASE_ID</th><th>RELEASE_NAME</th><th>RELEASE_STATUS_NAME</th></tr>
      <xsl:for-each select="ROW">
        <tr><td><xsl:value-of select="PROJECT_ID"/></td><td><xsl:value-of select="NAME"/></td><td><xsl:value-of select="PROJECT_GROUP_ID"/></td><td><xsl:value-of select="PROJECT_GROUP_NAME"/></td><td><xsl:value-of select="RELEASE_ID"/></td><td><xsl:value-of select="RELEASE_NAME"/></td><td><xsl:value-of select="RELEASE_STATUS_NAME"/></td>
        </tr>
      </xsl:for-each>
        </table>
    </xsl:template>
</xsl:stylesheet>