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_Name from 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_ID where 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: Version_Number Requirement_ID Req_Name Task_ID Task_Name Task_Status_Name 1.0.0.0 1.1.0.0 403 Build Something 20 Do Task 1 Completed 22 Do Task 2 Accepted 23 Do Task 3 Rejected Is there an easy way to build a template for this? The template I currently have is: Version_Number Requirement_ID Req_Name Task_ID Task_Name Task_Status_Name en-US(C) Copyright 2006-2026 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/issues-questions/719.aspxthreadId=719Mike Clarkson (mike.clarkson@tolko.com) 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_Name from 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_ID where 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: Version_Number Requirement_ID Req_Name Task_ID Task_Name Task_Status_Name 1.0.0.0 1.1.0.0 403 Build Something 20 Do Task 1 Completed 22 Do Task 2 Accepted 23 Do Task 3 Rejected Is there an easy way to build a template for this? The template I currently have is: Version_Number Requirement_ID Req_Name Task_ID Task_Name Task_Status_Name Fri, 20 Sep 2013 17:35:36 -04002014-08-20T14:25:13-04:00/Support/Forum/spirateam/issues-questions/719.aspxmessageId=1322David J (adam.sandman+support@inflectra.com) Anyone have any suggestions?Tue, 08 Oct 2013 14:54:42 -04002013-10-08T14:54:42-04:00/Support/Forum/spirateam/issues-questions/719.aspx#reply1322messageId=1781Jon Freed (jfreed@edmap.com)Try nested for-each tags? The first would be for releases, the second would be for release-requirements, and the third would be for release-requirement-tasks. Something like this (and yes, this pseudo code is definitely not valid/well-formed): td version number (with col span) 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 and req col(s)) tds for task cols Wed, 20 Aug 2014 14:25:13 -04002014-08-20T14:25:13-04:00/Support/Forum/spirateam/issues-questions/719.aspx#reply1781