I am trying to group data. I have a daily record that contains multiple projects and
multiple items in the project. I would like to roll the daily data into project 1 and all
the items that go with it and then project 2 and all the items that go with it. I have
a start but am unsure of where to go. I am attaching the files that I have.
Any help would be appreciated.
Thanks,
Dave
====================
<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="StatusReportProject.xsl" ?>
<TimeSheet>
<DailyTime Date="05/01/2005">
<WorkHours>
<Time Period="Day" Start="8:00 am" End="5:00 pm" />
<Time Period="Lunch" Start="12:00 pm" End="1:00 pm" />
<Time Period="AfterHours" Start="9:00 pm" End="11:00 pm" />
</WorkHours>
<Project Name="Project 1">
<Task Name="Task 1.1">
<WorkItemList Item="Task 1.1 - Item 1" />
<WorkItemList Item="Task 1.1 - Item 2" />
</Task>
<Task Name="Task 1.2">
<WorkItemList Item="Task 1.2 - Item 1" />
<WorkItemList Item="Task 1.2 - Item 2" />
</Task>
</Project>
<Project Name="Project 2">
<Task Name="Task 2.1">
<WorkItemList Item="Task 2.1 - Item 1" />
<WorkItemList Item="Task 2.1 - Item 2" />
</Task>
<Task Name="Task 2.2">
<WorkItemList Item="Task 2.2 - Item 1" />
<WorkItemList Item="Task 2.2 - Item 2" />
</Task>
</Project>
</DailyTime>
<DailyTime Date="05/02/2005">
<WorkHours>
<Time Period="Day" Start="7:00 am" End="4:00 pm" />
<Time Period="Lunch" Start="11:00 pm" End="12:00 pm" />
<Time Period="AfterHours" Start="9:00 pm" End="11:00 pm" />
</WorkHours>
<Project Name="Project 3">
<Task Name="Task 3.1">
<WorkItemList Item="Task 3.1 - Item 1" />
<WorkItemList Item="Task 3.1 - Item 2" />
</Task>
<Task Name="Task 3.2">
<WorkItemList Item="Task 3.2 - Item 1" />
<WorkItemList Item="Task 3.2 - Item 2" />
</Task>
</Project>
<Project Name="Project 1">
<Task Name="Task 1.1">
<WorkItemList Item="Task 1.1 - Item 1" />
<WorkItemList Item="Task 1.1 - Item 2" />
</Task>
<Task Name="Task 1.3">
<WorkItemList Item="Task 1.3 - Item 1" />
<WorkItemList Item="Task 1.3 - Item 2" />
</Task>
</Project>
</DailyTime>
</TimeSheet>
================================================== =
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/TimeSheet">
<HTML>
<HEAD>
<TITLE>Project Status Report</TITLE>
</HEAD>
<BODY>
<xsl:for-each select="DailyTime/Project">
<xsl:value-of select="@Name"/><br></br>
<xsl:call-template name="callTask"/>
<hr></hr>
</xsl:for-each>
</BODY>
</HTML>
</xsl:template>
<xsl:template name="callTask">
<xsl:for-each select="Task">
<OL>
<xsl:value-of select="@Name"/>
<xsl:call-template name="callWorkItemList"/>
</OL>
</xsl:for-each>
</xsl:template>
<xsl:template name="callWorkItemList">
<xsl:for-each select="WorkItemList">
<OL>
<xsl:value-of select="@Item"/>
</OL>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
========================================