SSDN - How to sum Nodes which are at child nodes

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

satish baleri

Subject: How to sum Nodes which are at child nodes
Author: satish baleri
Date: 22 Oct 2007 09:09 AM

Following is the xml file sample

<Records>
<Activity>
<ServiceType>Desktop Assessment</ServiceType>
<TotalHours>7</TotalHours>
</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>First Jurisdictional</ServiceType>
</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'

(Deleted User)

Subject: How to sum Nodes which are at child nodes
Author: (Deleted User)
Date: 25 Oct 2007 08:02 AM

Hi Satish,
which version of Stylus Studio are you using, and which XSLT processor have you selected in the Scenario Dialog?

Alberto

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.