[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Jacek Dunia wrote:
Does this do what you want?
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="list" match="/Calls/Row" use="TechnicianName" />
<xsl:output indent="yes"/>
<xsl:template match="Calls">
<html>
<body>
<table>
<thead>
<tr>
<th>Name</th>
<th>Total Work Time</th>
<th>Total Work Time INCYDENT</th>
<th>Total Work Time FAILURE</th>
<th>InTime</th>
<th>OutOfTime</th>
</tr>
</thead>
<tbody>
<xsl:for-each select="Row[count(. | key('list', TechnicianName)[1]) = 1]">
<tr>
<td><xsl:value-of select="TechnicianName" /></td>
<td><xsl:value-of select="sum(key('list', TechnicianName)/WorkTime)"/></td>
<td><xsl:value-of select="sum(key('list', TechnicianName)[ProblemType = 'INCYDENT']/WorkTime)" /></td>
<td><xsl:value-of select="sum(key('list', TechnicianName)[ProblemType = 'FAILURE']/WorkTime)" /></td>
<td><xsl:value-of select="count(key('list', TechnicianName)[Rc = 'InTime']/WorkTime)"/></td>
<td><xsl:value-of select="count(key('list', TechnicianName)[Rc = 'OutOfTime']/WorkTime)"/></td>
</tr>
--
Re: [xsl] Problem with sum values with double param
Subject: Re: [xsl] Problem with sum values with double param From: Martin Honnen <Martin.Honnen@xxxxxx> Date: Wed, 05 Aug 2009 18:49:29 +0200 |
Jacek Dunia wrote:
But my main problem remains, namely how to make other columns per Technican. When I normal use funcion sum() or count() with function key() I get values for all technicans, and I would like get for each technican. like this: Name TotalWorkTimeByIncydent TotalWorkTimeByFailure TotalWorkTime InTime OutOfTime Peter 30 0 30 1 1 Norman 40 150 200 2 1
Does this do what you want?
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="list" match="/Calls/Row" use="TechnicianName" />
<xsl:output indent="yes"/>
<xsl:template match="Calls">
<html>
<body>
<table>
<thead>
<tr>
<th>Name</th>
<th>Total Work Time</th>
<th>Total Work Time INCYDENT</th>
<th>Total Work Time FAILURE</th>
<th>InTime</th>
<th>OutOfTime</th>
</tr>
</thead>
<tbody>
<xsl:for-each select="Row[count(. | key('list', TechnicianName)[1]) = 1]">
<tr>
<td><xsl:value-of select="TechnicianName" /></td>
<td><xsl:value-of select="sum(key('list', TechnicianName)/WorkTime)"/></td>
<td><xsl:value-of select="sum(key('list', TechnicianName)[ProblemType = 'INCYDENT']/WorkTime)" /></td>
<td><xsl:value-of select="sum(key('list', TechnicianName)[ProblemType = 'FAILURE']/WorkTime)" /></td>
<td><xsl:value-of select="count(key('list', TechnicianName)[Rc = 'InTime']/WorkTime)"/></td>
<td><xsl:value-of select="count(key('list', TechnicianName)[Rc = 'OutOfTime']/WorkTime)"/></td>
</tr>
</xsl:for-each> </tbody> </table> </body> </html> </xsl:template> </xsl:stylesheet>
--
Martin Honnen http://msmvps.com/blogs/martin_honnen/
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Problem with sum values w, Jacek Dunia | Thread | Re: [xsl] Problem with sum values w, Jacek Dunia |
Re: [xsl] Problem with sum values w, Jacek Dunia | Date | [xsl] How to select for ' in X, Hermann Stamm-Wilbra |
Month |