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>
*************************