Okay, at the moment all I've been able to do is do the grouping bit. Basically, I've taken it as red that the OrderID is incremental which means that the smaller the OrderID the Older the order is and vice versa...I've mentioned that because your last Sale order has the highest number whereas it was done in the year 2004 - I've decided that that was probably a mistake!
So basically I've ordered the list by the OrderID and then grouped them using the year and date!
Unfortunately, as soon as I start trying to accumulate the Amounts I run into Namespace problems! If I alter the NameSpace then the order-by command doesn't work! The NameSpaces are really starting to annoy me!
Anyway, this is how far I've got - You've probably solved it already but that's life - I guess I'm going to start again trying to use the NameSpace I've been using for all my other interesting problems!
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
<xsl:template match="/">
<table border="1">
<xsl:for-each select="/Promotions/Promotion/Sale" order-by="@OrderID">
<tr>
<td>
<xsl:if expr="IsNewGroup(this)">
<xsl:eval>
SetCurrentGroup(this)
</xsl:eval>
<xsl:value-of select="@Date"/>
</xsl:if>
#160;</td>
<td><xsl:value-of select="@Amount"/>#160;</td>
<td><xsl:value-of select="@OrderID"/>#160;</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
<xsl:script language="JavaScript">
cCurrentGroup = "_empty_" ;
function SetCurrentGroup(cThis)
{
//Get the date value
cValue = cThis.attributes(0).nodeValue;
//Initialise the Group with the formatted date
cCurrentGroup = FormatDate(cValue);
}
function FormatDate(cDate)
{
//Create an array of the three date values
aDateTypes = cDate.split("/");
//Convert the three date values to integers so that we
//can group by year and month
cCurrentMonth = parseInt(aDateTypes[1]);
cCurrentYear = parseInt(aDateTypes[2]);
//Return the value
return (cCurrentYear * 100) + cCurrentMonth;
}
function IsNewGroup(cThis)
{
//Get the date value
cValue = cThis.attributes(0).nodeValue;
//Get the Formatted Date
cTest = FormatDate(cValue);
//Is the month and year the same as the last test
if (cTest == cCurrentGroup)
cReturn = false ;
else
cReturn = true ;
return cReturn ;
}
</xsl:script>
</xsl:stylesheet>
Grouping and totals
