[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Totalliing
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> *************************
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|