XSL XML Number count issue

[zambia]

First post so please excuse any Faux Pas's

I have an xml file as below

<?xml version="1.0"?>
<Car>
<Type>Ford Sierra</Type>
<Service>1
<Date>01/09/2006</Date>
<Tyres>OK</Tyres>
<Oil>Filled</Oil>
<Water>Filled </Water>
</Service>
<Service>2
<Date>01/09/2005</Date>
<Tyres>OK</Tyres>
<Oil>Filled</Oil>
<Water>Filled </Water>
</Service>
<Service>3
<Date>01/09/2004</Date>
<Tyres>OK</Tyres>
<Oil>Filled</Oil>
<Water>Filled </Water>
</Service>
</Car>

I want to produce the below xml file from this

<?xml version="1.0"?>
<CarHistory>
<Type>Ford Sierra</Type>
<NoOfServices>3 </NoOfServices>Fo rd Sierra
<ServiceDetails >
<ServiceNo>1</ServiceNo> <!-- note the count -->
<Date>01/09/2006</Date>
<Water>Filled </Water>
</ServiceDetails>
<ServiceDetails >
<ServiceNo>2</ServiceNo> <!-- note the count increase by 1 -->
<Date>01/09/2005</Date>
<Water>Filled </Water>
</ServiceDetails>
<ServiceDetails >
<ServiceNo>3</ServiceNo> <!-- note the count increase by 1 again and should do till end of services -->
<Date>01/09/2004</Date>
<Water>Filled </Water>
</ServiceDetails>
</CarHistory>

So far my xls looks like this

<?xml version='1.0' ?>
<xsl:styleshe et version="1.0" xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<CarHistory>
<Type>
<xsl:choose>< !-- Test to see if Type is there or if it has no value -->
<xsl:when test="Car/Type and '' != Car/Type"><!--If it is return the Value -->
<xsl:value-of select="Car/Type"/>
</xsl:when><!-- If its not return "Not Given" -->
<xsl:otherwise> Not Given</xsl:otherwise>
</xsl:choose>
</Type>
<NoOfServices >
<xsl:value-of select="count(C ar/Service)"/>
</NoOfServices>
<xsl:apply-templates/>
</CarHistory>
</xsl:template>
<xsl:template match="Service" >
<ServiceDetails >
<ServiceNo>
<!-- here lies the problem -->
</ServiceNo>
<Date>
<xsl:value-of select="Date"/>
</Date>
<Water>
<xsl:value-of select="Water"/>
</Water>
</ServiceDetails>
</xsl:template>
</xsl:stylesheet>

I wish to find the simplest way to have the <ServiceNo> increment by 1 each time around Position() does not seem to help me here as it increases by 2.

<xsl:number count="ServiceN o"/> fails as well as it has to go through a .net parser.

Thanks in advance.

Stan

[jkmyoung]

As stated in SSDN

<xsl:value-of select="1 + count(preceding ::ServiceNo)"/>

Don't know why .Net doesn't support <xsl:number> as it is an xslt 1.0 feature.
What version are you using?

According to this: http://www.topxml.com/xslt/ the number solution should be supported in MSXML 3 and up.