Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Qu... > Custom Report Builder Que...
I have the following query:
select REL.Version_Number, REQ.Requirement_ID, REQ.Name as Req_Name, T.Task_ID, T.Name as Task_Name, T.Task_Status_Namefrom SpiraTestEntities.R_Releases as REL left outer join SpiraTestEntities.R_Requirements as REQ on REL.Project_ID = REQ.Project_ID and REL.Release_ID = REQ.Release_ID and REQ.Is_Deleted=false left outer join SpiraTestEntities.R_Tasks as T on REL.Project_ID = T.Project_ID and REL.Release_ID = T.Release_ID and REQ.Requirement_ID = T.Requirement_IDwhere REL.PROJECT_ID = ${ProjectId}order by REL.Release_ID, T.Task_Status_ID
and I'm trying to build the template for the site to display the data like so:
Is there an easy way to build a template for this? The template I currently have is:
<?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>Version_Number</th> <th>Requirement_ID</th> <th>Req_Name</th> <th>Task_ID</th> <th>Task_Name</th> <th>Task_Status_Name</th> </tr> <tr> <td><xsl:value-of select="Version_Number"/></td> <td><xsl:value-of select="Requirement_ID"/></td> <td><xsl:value-of select="Req_Name"/></td> </tr> <xsl:for-each select="ROW/Task_ID"> <tr> <td></td> <td></td> <td></td> <td><xsl:value-of select="Task_ID"/></td> <td><xsl:value-of select="Task_Name"/></td> <td><xsl:value-of select="Task_Status_Name"/></td> </tr> </xsl:for-each> </table> </xsl:template></xsl:stylesheet>
<tr>
td version number (with col span)</tr>
td version number (with col span)
<for each requirement>
td empty col (with col span as desired to span the rel col(s))td req id (with col span as desired to span the task col(s))
td empty col (with col span as desired to span the rel col(s))
td req id (with col span as desired to span the task col(s))
</tr><for each task>
<tr>td empty col (with col span as desired to span the rel and req col(s))tds for task cols</tr></for each task></for each req>
<tr>td empty col (with col span as desired to span the rel and req col(s))tds for task cols</tr></for each task>
<tr>td empty col (with col span as desired to span the rel and req col(s))tds for task cols</tr>
td empty col (with col span as desired to span the rel and req col(s))
tds for task cols
And if you have any questions, please email or call us at +1 (202) 558-6885