Re: Grouping / Count Issue

> but what i want is:

$ saxon report.xml  report.xsl 
<?xml version="1.0" encoding="utf-8"?>
100US0100423003 3304
100US0100423013 332

101UK0200423003 4458
101UK0200423013 556


David


<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:key name="f" match="Field" use="@name"/>

<xsl:template match="/">
<xsl:text>
</xsl:text>

<xsl:for-each select="Report/GrandTotal/RecordValues/Record">

<xsl:variable name="v">
<xsl:for-each  select="FieldValue[key('f',@fieldName)/@dataType='V']">
<xsl:value-of select="@fieldValue"/>
</xsl:for-each>
</xsl:variable>

<xsl:for-each select="FieldValue[key('f',@fieldName)/@dataType='F']">
<xsl:value-of select="$v"/>
<xsl:value-of select="substring(key('f',@fieldName)/@title,1,2)"/>
<xsl:text> </xsl:text>
<xsl:value-of select="@fieldValue"/>
<xsl:text>
</xsl:text>
</xsl:for-each>
<xsl:text>
</xsl:text>
</xsl:for-each>

</xsl:template>

</xsl:stylesheet>


________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________