[xsl] Totalliing

Subject: [xsl] Totalliing
From: J_Eugene_Bernard/VML/IT/SGCORP/SANMAR@xxxxxxxxxxxxxxx
Date: Wed, 20 Oct 2004 16:06:47 +0530
Hi all,

Please find three files "stkmis5.xml","Stkmis5.htm" and stkmis.xsl 

I want to get a totalled sum for the nodes "Qty" and "Value" when i open 
the stkmis5.htm

any help greately appreciated

Thanks
Eugene


<<Contents of file stkmis5.xml>>

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' 
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' 
xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'>
<rs:data>
<z:row item='3000110'  desc='1 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       93.0000'  rate='        4.39'  value=' 
408.2700'/>
<z:row item='3000210'  desc='1 1/2 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      800.0000'  rate='        7.32'  value=' 
5856.0000'/>
<z:row item='3000310'  desc='2 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      967.0000'  rate='        8.64'  value=' 
8354.8800'/>
<z:row item='3000410'  desc='2 x 4 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      115.0000'  rate='        7.93'  value=' 
911.9500'/>
<z:row item='3000510'  desc='2 1/2 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      512.0000'  rate='       10.42'  value=' 
5335.0400'/>
<z:row item='3000610'  desc='2 1/2 x 4 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      840.0000'  rate='       10.32'  value=' 
8668.8000'/>
<z:row item='3000710'  desc='3 x 4 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='     1211.0000'  rate='       15.84'  value=' 
19182.2400'/>
<z:row item='3000810'  desc='3 x 6 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       80.0000'  rate='       20.75'  value=' 
1660.0000'/>
<z:row item='3001010'  desc='4 x 6 OPEN  EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='       96.0000'  rate='       30.27'  value='   2905.9200'/>
<z:row item='3001110'  desc='4 1/2 x 6 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      370.0000'  rate='       32.99'  value=' 
12206.3000'/>
<z:row item='3001610'  desc='KLX 86(S) PN  80 X 150 SLEEVE     '  uom='NOS 
 '  qty='       46.0000'  rate='       34.01'  value='   1564.4600'/>
<z:row item='3001710'  desc='KLX 86(S) PN  90 X 150 SLEEVE     '  uom='NOS 
 '  qty='       32.0000'  rate='       42.39'  value='   1356.4800'/>
<z:row item='3001810'  desc='KLX 86(S) PN 100 X 150 SLEEVE     '  uom='NOS 
 '  qty='       12.0000'  rate='       50.23'  value='    602.7600'/>
<z:row item='3001910'  desc='KLX 86(S) PN 125 X 150 SLEEVE     '  uom='NOS 
 '  qty='      141.0000'  rate='       74.30'  value='  10476.3000'/>
<z:row item='3001930'  desc='KLX N200 OPEN SLEEVE     '  uom='NOS  ' qty=' 
     310.0000'  rate='      127.15'  value='  39416.5000'/>
<z:row item='3002510'  desc='5 1/2 X 6 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       10.0000'  rate='       35.88'  value=' 
358.8000'/>
<z:row item='3002610'  desc='5 X 8 OPEN EXOTHERMIC SLEEVES     '  uom='NOS 
 '  qty='        4.0000'  rate='       44.00'  value='    176.0000'/>
<z:row item='3002710'  desc='5 1/2 X 8 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       52.0000'  rate='       35.97'  value=' 
1870.4400'/>
<z:row item='3002810'  desc='6 X 6 OPEN  EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='      118.0000'  rate='       41.30'  value='   4873.4000'/>
<z:row item='3002910'  desc='8 X 6 OPEN EXOTHERMIC SLEEVES     '  uom='NOS 
 '  qty='       73.0000'  rate='       68.53'  value='   5002.6900'/>
<z:row item='3003010'  desc='7 X 6 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='       47.0000'  rate='       62.76'  value='   2949.7200'/>
<z:row item='3003110'  desc='9 X 6 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='       70.0000'  rate='       85.50'  value='   5985.0000'/>
<z:row item='3003210'  desc='6 1/2 X 6 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       97.0000'  rate='       50.89'  value=' 
4936.3300'/>
<z:row item='3003310'  desc='6 1/2 X 8 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       20.0000'  rate='       66.70'  value=' 
1334.0000'/>
<z:row item='3003410'  desc='3 1/2 x 8 OPEN SLEEVE     '  uom='NOS  ' 
qty='       21.0000'  rate='       33.54'  value='    704.3400'/>
<z:row item='3003510'  desc='6 x 8 OPEN SLEEVE     '  uom='NOS  '  qty='   
  3.0000'  rate='       54.94'  value='    164.8200'/>
<z:row item='3003610'  desc='5 X 4 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='       37.0000'  rate='       22.13'  value='    818.8100'/>
<z:row item='3005210'  desc='11 X 15 OPEN EXOTHERMIC SLEEVE     ' uom='NOS 
 '  qty='       36.0000'  rate='      308.16'  value='  11093.7600'/>
<z:row item='3005310'  desc='11 X 15 OPEN SLEEVE (KALMIN 81 N275)     ' 
uom='NOS  '  qty='        6.0000'  rate='      138.40'  value=' 
830.4000'/>
<z:row item='3005510'  desc='4 X 5 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='      202.0000'  rate='       23.11'  value='   4668.2200'/>
<z:row item='3005610'  desc='2 1/2 x 6 OPEN SLEEVE     '  uom='NOS  ' 
qty='      228.0000'  rate='       15.49'  value='   3531.7200'/>
<z:row item='3005710'  desc='5 1/2 X 9 OPEN SLEEVE     '  uom='NOS  ' 
qty='       91.0000'  rate='       37.13'  value='   3378.8300'/>
<z:row item='3005810'  desc='1 1/2 X 4 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      382.0000'  rate='        7.01'  value=' 
2677.8200'/>
<z:row item='3005910'  desc='2 X 6 OPEN SLEEVE     '  uom='NOS  '  qty='   
 43.0000'  rate='       11.85'  value='    509.5500'/>
<z:row item='3006110'  desc='10 X 15 OPEN EXOTHERMIC SLEEVE     ' uom='NOS 
 '  qty='       11.0000'  rate='      317.81'  value='   3495.9100'/>
<z:row item='3006210'  desc='4 1/2 X 3 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       20.0000'  rate='       15.00'  value=' 
300.0000'/>
<z:row item='3006410'  desc='5 1/2 X 4 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       11.0000'  rate='       24.54'  value=' 
269.9400'/>
<z:row item='3006610'  desc='3 1/2 X 4 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       28.0000'  rate='       15.05'  value=' 
421.4000'/>
<z:row item='3006710'  desc='4 1/2 X 8 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='        2.0000'  rate='       39.88'  value=' 79.7600'/>
<z:row item='3006810'  desc='14 X 6 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='        7.0000'  rate='      265.20'  value='   1856.4000'/>
<z:row item='30F3110'  desc='N225 KALMIN 81 (9 X 8) INSULATING SLEEVE  ' 
uom='NOS  '  qty='        1.0000'  rate='      104.63'  value=' 
104.6300'/>
<z:row item='30F3610'  desc='N250 KALMINEX 30 (10 X 8) OPEN EXO SLEEVE  ' 
uom='NOS  '  qty='      318.0000'  rate='      190.46'  value=' 
60566.2800'/>
<z:row item='30F4910'  desc='N180 KALMINEX 30 (7X8) EXOTHERMIC SLEEVE  ' 
uom='NOS  '  qty='      177.0000'  rate='      130.81'  value=' 
23153.3700'/>
<z:row item='30F5010'  desc='N150 KALMINEX 30 (6X8) EXOTHERMIC SLEEVE  ' 
uom='NOS  '  qty='      220.0000'  rate='       98.87'  value=' 
21751.4000'/>
<z:row item='3100110'  desc='1 x 3 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       83.0000'  rate='        4.83'  value=' 
400.8900'/>
<z:row item='3100210'  desc='1 1/2 x 3  BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='     1676.0000'  rate='        7.33'  value=' 
12285.0800'/>
<z:row item='3100310'  desc='2 x 3 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='     2451.0000'  rate='        9.42'  value=' 
23088.4200'/>
<z:row item='3100410'  desc='2 x 4 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      391.0000'  rate='        8.71'  value=' 
3405.6100'/>
<z:row item='3100510'  desc='2 1/2 x 3 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      130.0000'  rate='        7.75'  value=' 
1007.5000'/>
<z:row item='3100610'  desc='2 1/2 x 4 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      252.0000'  rate='       11.19'  value=' 
2819.8800'/>
<z:row item='3100710'  desc='3 x 4 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       55.0000'  rate='       14.28'  value=' 
785.4000'/>
<z:row item='3100810'  desc='3 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       50.0000'  rate='       19.16'  value=' 
958.0000'/>
<z:row item='3100910'  desc='3 1/2 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       67.0000'  rate='       24.67'  value=' 
1652.8900'/>
<z:row item='3101010'  desc='4 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       28.0000'  rate='       28.42'  value=' 
795.7600'/>
<z:row item='3101110'  desc='4 1/2 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       21.0000'  rate='       33.68'  value=' 
707.2800'/>
<z:row item='3101410'  desc='KLX 86(S) PN SFP 6/9K SLEEVE     '  uom='NOS 
'  qty='     1200.0000'  rate='       18.83'  value='  22596.0000'/>
<z:row item='3101510'  desc='KLX 86(S) PN SFP 7/10K SLEEVE     '  uom='NOS 
 '  qty='     1100.0000'  rate='       25.41'  value='  27951.0000'/>
<z:row item='3102410'  desc='5 X 6 BLIND EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='       73.0000'  rate='       32.72'  value='   2388.5600'/>
<z:row item='3102510'  desc='5 1/2 X 6 BLIND EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       66.0000'  rate='       36.78'  value=' 
2427.4800'/>
<z:row item='3105610'  desc='2 1/2 X 6 BLIND SLEEVE     '  uom='NOS  ' 
qty='       60.0000'  rate='       15.47'  value='    928.2000'/>
<z:row item='3105810'  desc='1 1/2 X 4 BLIND EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      229.0000'  rate='        7.60'  value=' 
1740.4000'/>
<z:row item='3105910'  desc='2 X 6 BLIND SLEEVE     '  uom='NOS  '  qty='  
   153.0000'  rate='       12.13'  value='   1855.8900'/>
<z:row item='3K00110'  desc='KALPUR ST 90 X 200     '  uom='NOS  '  qty='  
    10.0000'  rate='      565.22'  value='   5652.2000'/>
<z:row item='3K00210'  desc='KALPUR ST 70 X 175     '  uom='NOS  '  qty='  
   204.0000'  rate='      303.47'  value='  61907.8800'/>
<z:row item='3K00310'  desc='KALPAD 10 300 X 300 20     '  uom='NOS  ' 
qty='        8.0000'  rate='      193.60'  value='   1548.8000'/>
<z:row item='3K00410'  desc='KALMIN 70 M PN 70X100     '  uom='NOS  ' 
qty='       50.0000'  rate='       13.60'  value='    680.0000'/>
<z:row item='3K00610'  desc='KALMIN 70 M PN100X150     '  uom='NOS  ' 
qty='       91.0000'  rate='       24.86'  value='   2262.2600'/>
<z:row item='3K00710'  desc='KALPUR ST 50 X 150     '  uom='NOS  '  qty='  
    44.0000'  rate='      167.42'  value='   7366.4800'/>
</rs:data>
</xml>



<< contents of stkmis5.htm>>

<HTML>
<BODY>
<HEAD>
<TITLE> Stores Stock Statement - Scrap</TITLE>
        <SCRIPT LANGUAGE="JavaScript" FOR="window" EVENT="onload">
                showSorted('item','number')
        </SCRIPT>
        <SCRIPT LANGUAGE="JavaScript">
        function showSorted(SortOrder,SortType)
        {
        /* Converted to JavaScript from a code of Trace Wilson at
        http://www.vbxml.com/snippetcentral
        How to pass values into an XSLT stylesheet from ASP */
                var xml = new 
ActiveXObject("Msxml2.FreeThreadedDOMDocument");
                var xsl = new 
ActiveXObject("Msxml2.FreeThreadedDOMDocument");
                xml.async = false;
                xsl.async = false;
                xml.load ("stkmis5.xml");
                xsl.load ("stkmis.xsl");
                var template = new ActiveXObject("Msxml2.XSLTemplate");
                template.stylesheet = xsl;
                var myProc = template.createProcessor();
                myProc.input = xml; //XML_RptFormat.documentElement;
                myProc.addParameter ("SortBy",SortOrder);
                myProc.addParameter ("SortType",SortType);
                myProc.transform;
                RptData.innerHTML = myProc.output; 
        }
        </SCRIPT>
</HEAD>
<a href="x:\stores\stkmis1.htm">Ferro Alloys</a>
<a href="x:\stores\stkmis2.htm">Returns</a>
<a href="x:\stores\stkmis3.htm">Mould Coat</a>
<a href="x:\stores\stkmis.htm">Scrap</a>
<BODY BGCOLOR="#FFFFFF">
<DIV ID="RptData"> </DIV>
</BODY>
</HTML>



<<Contents of stkmis.xsl>>

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
  exclude-result-prefixes="rs z"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
  xmlns:rs="urn:schemas-microsoft-com:rowset"
  xmlns:z="#RowsetSchema">
<xsl:output method="html"/>
<xsl:param name = "SortBy"/>
<xsl:param name = "SortType" select='number'/>
<xsl:template match="/">
<HTML><BODY>
<h4>SANMAR FOUNDRIES LIMITED - STOCK STATUS</h4>
<TABLE border='1' cellspacing="" cellpadding="4">
  <TR bgcolor='#FFFF00'>
                <TD width='75'><A 
HREF="javascript:showSorted('item','text')">Item Code</A></TD>
                <TD width='100'><A 
HREF="javascript:showSorted('desc','text')">Item Description</A></TD>
                <TD width='75'><A 
HREF="javascript:showSorted('uom','number')">UOM</A></TD>
                <TD width='100'><A 
HREF="javascript:showSorted('qty','number')">Quantity</A></TD>
                <TD width='75' ><A 
HREF="javascript:showSorted('rate','number')">Rate</A></TD>
                <TD width='75' ><A 
HREF="javascript:showSorted('value','number')">Value</A></TD>
  </TR>
  <xsl:apply-templates select="xml/rs:data/z:row">
                <xsl:sort select ='@*[name(.) = $SortBy]' 
data-type="{$SortType}"/>
  </xsl:apply-templates>
</TABLE></BODY></HTML>
</xsl:template>

<xsl:template match = "z:row">
        <TR> 
                <TD><xsl:value-of select='@item'/></TD>
                <TD><xsl:value-of select='@desc'/></TD>
                <TD><xsl:value-of select='@uom'/></TD>
                <TD align="right"><xsl:value-of select='@qty'/></TD> 
                <TD align="right"><xsl:value-of select='@rate'/></TD>  
<TD align="right"><xsl:value-of select='@value'/></TD> 
        </TR>
</xsl:template> 
</xsl:stylesheet>

*************************

Current Thread