Subject: Re: [xsl] Problem with sum values with double param From: Martin Honnen <Martin.Honnen@xxxxxx> Date: Wed, 05 Aug 2009 15:52:42 +0200 |
<Calls> <Row NR="1"> <Rc>InTime</Rc> <WorkTime>20</WorkTime> <TechnicianName>Norman</TechnicianName> <ProblemType>INCYDENT</ProblemType> </Row> <Row NR="2"> <Rc>OutTime</Rc> <WorkTime>10</WorkTime> <TechnicianName>Peter</TechnicianName> <ProblemType>INCYDENT</ProblemType> </Row> <Row NR="3"> <Rc>InTime</Rc> <WorkTime>150</WorkTime> <TechnicianName>Norman</TechnicianName> <ProblemType>FAILURE</ProblemType> </Row> <Row NR="4"> <Rc>OutOfTime</Rc> <WorkTime>10</WorkTime> <TechnicianName>Norman</TechnicianName> <ProblemType>RemoteAccess</ProblemType> </Row> <Row NR="5"> <Rc>InTime</Rc> <WorkTime>20</WorkTime> <TechnicianName>Norman</TechnicianName> <ProblemType>INCYDENT</ProblemType> </Row> <Row NR="6"> <Rc>InTime</Rc> <WorkTime>20</WorkTime> <TechnicianName>Peter</TechnicianName> <ProblemType>INCYDENT</ProblemType> </Row> I would like get following out put Name TotalWorkTimeByIncydent TotalWorkTimeByFailure TotalWorkTime InTime OutOfTime Peter 30 0 30 1 1 Norman 40 150 200 2 1
Thecnican name can't be duplicate so I make like this: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:key name="list" match="/Activities/Row" use="TechnicianNames" />
<xsl:template match="Activities">
<html> <body> <xsl:variable name="var_TechnicianNamess" select="/Activities/Row[count(. | key('list', TechnicianName)[1]) = 1]"/> <xsl:for-each select="$var_TechnicianNamess"> <xsl:value-of select="TechnicianName" /> <xsl:value-of select="sum(WorkMinute)" />
Martin Honnen http://msmvps.com/blogs/martin_honnen/
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Problem with sum values with , Jacek Dunia | Thread | Re: [xsl] Problem with sum values w, Jacek Dunia |
[xsl] Problem with sum values with , Jacek Dunia | Date | Re: [xsl] Problem with sum values w, Jacek Dunia |
Month |