Following is the xml file sample

<Records>
  <Activity>
    <ServiceType>Desktop Risk Assessment</ServiceType>
    <TotalHours>9</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>732.5</TotalCost>
  </Activity>
  <Activity>
    <ServiceType>Engineering Follow Up</ServiceType>
    <TotalHours>4</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>400</TotalCost>
  </Activity>
  <Activity>
    <ServiceType>Engineering Follow Up</ServiceType>
    <LocationCount>1</LocationCount>
    <VisitCount>2</VisitCount>
    <TotalHours>8</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>832.5</TotalCost>
  </Activity>
<Activity>
    <ServiceType>Engineering Follow Up</ServiceType>
    <LocationCount>1</LocationCount>
    <VisitCount>7</VisitCount>
    <TotalHours>9</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>732.5</TotalCost>
  </Activity>
<Activity>
    <ServiceType>Engineering Follow Up</ServiceType>
    <LocationCount>1</LocationCount>
    <VisitCount>3</VisitCount>
    <TotalHours>5</TotalHours>
    <TotalExpenses>20</TotalExpenses>
    <TotalCost>632.5</TotalCost>
  </Activity>
  <Activity>
    <ServiceType>First Jurisdictional</ServiceType>
    <TotalHours>9</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>732.5</TotalCost>
  </Activity>
</Records>

Based on the ServiceType I have to sum up 'TotalHours'

for example we have 'Engineering Follow Up' based on this we have to sum 'TotalHours' , TotalCost etc in xslt 1.0 and it cannot be hard coded 'Engineering Follow Up'

OUTPUT
Desktop Risk Assessment

<TotalHours>9</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>732.5</TotalCost>
Engineering Follow Up
<TotalHours>26</TotalHours>
<TotalCost>3666.77</TotalCost>

First Jurisdictional
<TotalHours>9</TotalHours>
    <TotalExpenses>0</TotalExpenses>
    <TotalCost>732.5</TotalCost>


Please find the xslt

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:sl="http://schemas.microsoft.com/schemaLibrary/2003/core" xmlns:aml="http://schemas.microsoft.com/aml/2001/core" xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns:ms="urn:schemas-microsoft-com:xslt" xmlns:exslt="http://exslt.org/common" xmlns:date="http://exslt.org/dates-and-times">

<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>


<xsl:template match="Records">
    <xsl:apply-templates select="Activity">
     <xsl:sort select="ServiceType" order="ascending" data-type="number" />
    </xsl:apply-templates>
</xsl:template>


    <xsl:template match="Activity">
    <xsl:choose>
    
     <xsl:when test="(ServiceType = 'Engineering Follow Up')">

         <xsl:variable name="EngFollowUpTotalHrs" select="sum(//Activity[ServiceType='Engineering Follow Up']/TotalHours)"/>
         <xsl:value-of select="$EngFollowUpTotalHrs" />
         <xsl:variable name="EngFollowUpTotalExp" select="sum(//Activity[ServiceType='Engineering Follow Up']/TotalExpenses)"/>
         <xsl:value-of select="$EngFollowUpTotalExp" />
         <xsl:variable name="EngFollowUpTotalCost" select="sum(//Activity[ServiceType='Engineering Follow Up']/TotalCost)"/>
         <xsl:value-of select="$EngFollowUpTotalCost" />

     </xsl:when>
     <xsl:otherwise>
        <xsl:value-of select="ServiceType" />

     </xsl:otherwise>
    </xsl:choose >

</xsl:template>

</xsl:stylesheet>

I am using xslt 1.0.

I tried with for each loop , but First time it will enter in to the
Engg Follow up,it is summming up under this type ,second time it is again going in to the loop. I have to prevent to enter in to second time, If condtion or can we set Flag. Please suggest me

Thanks

Look at the first post in the XSLT forum. There is a link to grouping in version 1.0. You need to group on ServiceType using a key, then you can sum.

--

Joe (Microsoft MVP - XML)

Hi joefawcett,

I am new to this key concept , Can you modify this xslt

Thanks
satish

No, the forums designed for help, if you want me to do the work for you then we can talk about a contract.

--

Joe (Microsoft MVP - XML)

You appear to be doing the following as well:

<xsl:sort select="ServiceType" order="ascending" data-type="number" />

ServiceType isn't a number.

/- Sam Judson : Wrox Technical Editor -/

You haven't shown the output you want, but if you want a total across activities, then I wouldn't expect to be computing it while processing an individual activity. I would expect to see something like

<xsl:template match="Records">
  <total activity="{$param}">
    <xsl:value-of select="sum(Activity[ServiceType=$param]/TotalHours"/>
  </total>
</xsl:template>


Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference