|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Grouping by Node & Node Attributr
It's a standard grouping problem, read up on grouping at http://www.jenitennison.com/xslt/grouping It's much easier if you can switch to XSLT 2.0. Michael Kay http://www.saxonica.com/ > -----Original Message----- > From: jeb501@xxxxxxxxxxxxxxx [mailto:jeb501@xxxxxxxxxxxxxxx] > Sent: 30 October 2006 06:32 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: Grouping by Node & Node Attributr > > > > > > Hi all, > > WIth following XML & XSL files, after transformation i get an html > > file as below. > > XML : > > <?xml version="1.0" ?> > + <sum> > - <record> > <mon cat="OT">Sep2005</mon> > <qty>3.00</qty> > <weight>15.66000</weight> > </record> > - <record> > <mon cat="1X">Sep2005</mon> > <qty>12.00</qty> > <weight>36.12000</weight> > </record> > - <record> > <mon cat="OT">Sep2005</mon> > <qty>2.00</qty> > <weight>39.90000</weight> > </record> > - <record> > <mon cat="1X">Sep2005</mon> > <qty>16.00</qty> > <weight>7.05600</weight> > </record> > - <record> > <mon cat="1X">Sep2005</mon> > <qty>32.00</qty> > <weight>12.48000</weight> > </record> > </sum> > > > XSL : > > <?xml version="1.0" encoding="ISO-8859-1" ?> > - <xsl:stylesheet version="1.0" xmlns:xsl=" > http://www.w3.org/1999/XSL/Transform"> > - <xsl:template match="/"> > - <html> > - <body> > - <table border="1" cellpadding="4" cellspacing="0"> > - <tr bgcolor="#9acd32"> > <th rowspan="2">Month</th> > <th rowspan="2">Cat</th> > <th colspan="2">P Qty</th> > </tr> > - <tr bgcolor="#9acd32"> > <th>Qty</th> > <th>Value</th> > </tr> > - <xsl:for-each select="sum/record"> > - <tr> > - <td> > <xsl:value-of select="mon" /> > </td> > - <td> > <xsl:value-of select="mon/@cat" /> > </td> > - <td align="right"> > <xsl:value-of select="qty" /> > </td> > - <td align="right"> > <xsl:value-of select="weight" /> > </td> > </tr> > </xsl:for-each> > </table> > </body> > </html> > </xsl:template> > </xsl:stylesheet> > > HTML actual Output :
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Cast Your Vote
We need your help – Vote for DataDirect XML Products!
Winners and finalists announced at SOA World Conference in November. 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
|







