XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
zakir techSubject: count in XSLT, Need Help Please !!!
Author: zakir tech
Date: 15 Dec 2008 12:50 AM
Hi,
I am creating a report using a xml (Input File(Source).
In the xml I have Parents Source , Then I have ID, S_ID, Name , Discription, DATE, TIME and STATUS , For Each ID I will be having 96 DATE and TIME, some time I may have 80 or 70 also , But max count will be 96.
I am getting all the column correct in the report, now I am trying to get a new column TOTAL COUNT ( which count all the Date / Time / Status, STATUS value will be "1" by default. If I sum the STATUS.

Below is the XSLT iam trying to right , but If I use count it is displaying 2796 in each, I didn't put the whole xml here I just added 4 - 5 count here as an example.
why I am getting 2796 ( becuase I pulled 1 month i data means 31 days each day will have 96 S_ID , DATE, TIME, STATUS) so the XSLT is count 96 * 31 and displaying 2796 in each row.
The ID is also unique for 96 Measure

MY XML :
<?xml version="1.0" encoding="UTF-8"?>
<envelope>
<sources>
<source>
<data>
<xml_transfer xmlns="" version="V1.2">
<REPORT>
<EM_ESOURCE>
<MEASURE>
<ID>1403157</ID>
<S_ID>1017502</S_ID>
<AMOUNT>13.446961</AMOUNT>
<DATE>2007-01-01</START_DATE>
<TIME>05:44:00</START_TIME>
<STATUS>1</STATUS>
<MATERIAL_TEXT>
<NAME>BBB</NAME>
</MATERIAL_TEXT>
</MEASURE>
<MEASURE>
<ID>1403158</ID>
<S_ID>1017502</S_ID>
<AMOUNT>13.211704</AMOUNT>
<DATE>2007-01-01</DATE>
<TIME>05:59:00</TIME>
<STATUS>1</STATUS>
<MATERIAL_TEXT>
<NAME>ABC</NAME>
</MATERIAL_TEXT>
</MEASURE>
<MEASURE>
<ID>1403159</ID>
<S_ID>1017502</S_ID>
<AMOUNT>13.432246</AMOUNT>
<DATE>2007-01-01</DATE>
<TIME>06:14:00</TIME>
<STATUS>1</STATUS>
<MATERIAL_TEXT>
<NAME>JJJ</NAME>
</MATERIAL_TEXT>
</MEASURE>
<MEASURE>
<ID>1403160</ID>
<S_ID>1017502</S_ID>
<AMOUNT>13.805982</AMOUNT>
<DATE>2007-01-01</DATE>
<TIME>06:29:00</TIME>
<STATUS>1</STATUS>
<MATERIAL_TEXT>
<NAME>KKK</NAME>
<MATERIAL_TEXT>
</MEASURE>

.***********<96 MEASURE> element*********
<MEASURE>
<ID>1403160</ID>
<S_ID>1017502</S_ID>
<AMOUNT>13.805982</AMOUNT>
<DATE>2007-01-02</DATE>
<TIME>06:29:00</TIME>
<STATUS>1</STATUS>
<MATERIAL_TEXT>
<NAME>KKK</NAME>
<MATERIAL_TEXT>
</MEASURE>
*********************************
( 96 <MEASURE>)
**********
MY XSLT :

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="text()|@*"/>
<xsl:key name="fact" match="MEASURE" use="concat(S_ID, ' ', DATE)"/>
<xsl:template match="//rep:envelope/rep:sources/rep:source/rep:data/xml_transfer/REPORT">
<HTML>
<!-- Headers -->
<table><tr><td align="left" colspan="7"><font size="5"><b><i><u>My Report</u></i></b></font></td></tr> <!-- Report title -->
<tr><td/></tr></table>
<table><tr><td/></tr></table>

<table border="1"> <!-- Headers -->
<tr>
<th colspan="7">Parent Facility</th>
<th>NAME</th>
<th>DESCRIPTION</th>
<th>TYPE</th>
<th>IDENTIFIER</th>
<th>PARAMETER</th>
<th>DATE</th>
<th>TOTAL COUNT</th>
</tr>
</table>
<xsl:for-each select="ESOURCE">
<table border="1"><tr>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last()]/NAME"/></td>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last() - 1]/NAME"/></td>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last() - 2]/NAME"/></td>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last() - 3]/NAME"/></td>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last() - 4]/NAME"/></td>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last() - 5]/NAME"/></td>
<td><xsl:value-of select="descendant::ESOURCE_TEXT[last() - 6]/NAME"/></td>
<td><xsl:value-of select="ESOURCE_TEXT/NAME"/></td>
<td><xsl:value-of select="ESOURCE_TEXT/DESCRIPTION"/></td>
<td><table><xsl:for-each select="MEASURE[count(. | key('fact', concat(S_ID, ' ', MAT_ID, ' ', DATE))[1]) = 1]">
<xsl:sort select="MATERIAL_TEXT/NAME"/>
<xsl:sort select="DATE"/>
<tr>
<td><xsl:value-of select="MATERIAL_TEXT/NAME"/></td>
<td><xsl:value-of select="START_DATE"/></td>
<td><xsl:value-of select="count(//STATUS[.=current()/STATUS])"/></td>
</tr>
</xsl:for-each></table></td>
</tr></table>
</xsl:for-each>
</HTML>
</xsl:template>
</xsl:stylesheet>

Posttop
Alberto MassariSubject: count in XSLT, Need Help Please !!!
Author: Alberto Massari
Date: 15 Dec 2008 01:19 PM
Hi Zachir,
which version of Stylus Studio are you using, and which processor have you selected in the scenario dialog?

Alberto

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.