Hi all
Using the below XML data (Partial listing) and XSL, I am getting the
HTML output as below.
How to make it to compact horizontally tabulated HTML output like this
(to limit the size of my mail i have removed html tags)
HTML Output :
Code Due Press ID Qty
---------------------------------------------
A001
----------------------------------------------
Beyond Mar
Press A 100
Press B 219
Feb Due
Press A 47
Press B 365
Mar Due
Press A 84
Press B 256
Over Due
Press B 2
--------------------------------
HTML Output (Desired):
CODE BEYOND MAR FEB DUE MAR DUE OVER DUE
A B C D A B C D A B C
D A B C D
A001 100 219 47 365 84 256
2
XML:
<?xml version="1.0" ?>
- <mpour>
- <item>
<ccode>A004</ccode>
<due>Beyond Mar</due>
<line>Press A</line>
<pour>409</pour>
<weight>3476.50</weight>
</item>
- <item>
<ccode>A004</ccode>
<due>Beyond Mar</due>
<line>Press A</line>
<pour>300</pour>
<weight>2550.00</weight>
</item>
- <item>
<ccode>A004</ccode>
<due>Beyond Mar</due>
<line>Press A</line>
<pour>500</pour>
<weight>4250.00</weight>
</item>
- <item>
XSL :
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="mpour">
<table border="1" cellspacing="0"
cellpadding="4"><tr><td>Code</td><td>Due</td><td>Press
ID</td><td>Qty</td></tr>
<xsl:for-each-group select="item" group-by="ccode">
<xsl:sort select="current-grouping-key()"/>
<tr>
<td><xsl:value-of select="ccode"/></td>
<td/>
<td/>
<td/>
</tr>
<xsl:for-each-group select="current-group()" group-by="due">
<xsl:sort select="current-grouping-key()"/>
<tr>
<td/>
<td><xsl:value-of select="due"/></td>
<td/>
<td/>
</tr>
<xsl:for-each-group select="current-group()" group-by="line">
<xsl:sort select="current-grouping-key()"/>
<tr>
<td/>
<td/>
<td><xsl:value-of select="line"/></td>
<td align="right"><xsl:value-of
select="format-number(sum(current-group()/pour),'######.##')" /></td>
</tr>
</xsl:for-each-group>
</xsl:for-each-group>
</xsl:for-each-group>
</table>
</xsl:template>
</xsl:stylesheet>
Regards
Eugene
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--