Custom Report

The good news is that the custom reporting features of SpiraTeam make this easy to achieve. You simply create a new report and add a custom section to the report:

The SQL you need to use for the custom section would be:

select
  D.PROJECT_ATTACHMENT_FOLDER_NAME as FOLDER_NAME,
  'DC' + cast (D.ATTACHMENT_ID as String) as DOCUMENT_ID,
  D.FILENAME as DOCUMENT_NAME,
  U.FIRST_NAME + ' ' + U.LAST_NAME as AUTHOR_NAME,
  D.CURRENT_VERSION
from SpiraTestEntities.R_Attachments as D
inner join SpiraTestEntities.R_Users as U on D.AUTHOR_ID = U.USER_ID
where D.PROJECT_ID = ${ProjectId}
order by D.FILENAME

and you can either have SpiraTeam generate the default template for this query, or use the following version (that has the column names prettified):

<?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>Folder Name</th><th>Document ID</th><th>Document Name</th><th>Author</th><th>Current Version</th></tr>
      <xsl:for-each select="ROW">
        <tr><td><xsl:value-of select="FOLDER_NAME"/></td><td><xsl:value-of select="DOCUMENT_ID"/></td><td><xsl:value-of select="DOCUMENT_NAME"/></td><td><xsl:value-of select="AUTHOR_NAME"/></td><td><xsl:value-of select="CURRENT_VERSION"/></td>
        </tr>
      </xsl:for-each>
        </table>
    </xsl:template>
</xsl:stylesheet>

The resulting output would be:

FOLDER_NAMEDOCUMENT_IDDOCUMENT_NAMEAUTHOR_NAMECURRENT_VERSION
Design DocumentsDC8Author Management Screen Wireframe.vsdJoe Smith2.1
SpecificationsDC1Book Management Functional Spec.docFred Bloggs2
Design DocumentsDC11Book Management Screen Wireframe.aiJoe Smith1.1
Error MessagesDC10Bug Stack Trace.txtJoe Smith1
Screen CapturesDC5Cannot Sort Screenshot.pptFred Bloggs1
Screen CapturesDC9Date Editing Screenshot.jpgJoe Smith1
Screen CapturesDC3Error Logging-in Screen-shot.gifFred Bloggs1
Error MessagesDC4Error Stacktrace.docFred Bloggs1