Dear All,
I have a problem in defining XSLT for the following input and expected
output format
Please Help. I am using XSLT 1.0 version. And Dotnet Framework is 2.0
Input XML is
<NewDataSet>
<Lines>
<ColKey>2008</ColKey>
<RowKey>JAN</RowKey>
<CategoryName>SALES </CategoryName>
<A1>-422976806.00000</A1>
<A2>-3807391165.06000</A2>
<A3>0.00000</A3>
<Total>-4230367971.06000</Total>
</Lines>
<Lines>
<ColKey>2008</ColKey>
<RowKey>JAN</RowKey>
<CategoryName>PROFIT</CategoryName>
<A1>-4055338042.00000</A1>
<A2>-4813647070.00000</A2>
<A3>0.00000</A3>
<Total>-8868985112.00000</Total>
</Lines>
<Lines>
<ColKey>2009</ColKey>
<RowKey>JAN</RowKey>
<CategoryName>SALES</CategoryName>
<A1>-18595059667.66000</A1>
<A2>47537164177.41000</A2>
<A3>0.00000</A3>
<Total>28942104509.75000</Total>
</Lines>
<Lines>
<ColKey>2009</ColKey>
<RowKey>JAN</RowKey>
<CategoryName>PROFIT</CategoryName>
<A1>-18595059667.66000</A1>
<A2>47537164177.41000</A2>
<A3>0.00000</A3>
<Total>28942104509.75000</Total>
</Lines>
<Lines>
<ColKey>2010</ColKey>
<RowKey>JAN</RowKey>
<CategoryName>SALES</CategoryName>
<A1>-982334530.00000</A1>
<A2>-4036020530.00000</A2>
<A3>0.00000</A3>
<Total>-5018355060.00000</Total>
</Lines>
<Lines>
<ColKey>2010</ColKey>
<RowKey>JAN</RowKey>
<CategoryName>PROFIT</CategoryName>
<A1>-982334530.00000</A1>
<A2>-4036020530.00000</A2>
<A3>0.00000</A3>
<Total>-5018355060.00000</Total>
</Lines>
<Lines>
<ColKey>2010</ColKey>
<RowKey>FEB</RowKey>
<CategoryName>PROFIT</CategoryName>
<A1>-982334530.00000</A1>
<A2>-4036020530.00000</A2>
<A3>0.00000</A3>
<Total>-5018355060.00000</Total>
</Lines>
</NewDataSet>
Expected Output format HTML format is
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Untitled Page</title>
</head>
<body>
<table border="1" cellpadding="1" cellspacing="0">
<thead><tr><td rowspan="2">Month</td><td
rowspan="2">CategoryName</td><td colspan="4" align="center">2008</td>
<td colspan="4" align="center">2009</td><td colspan="4"
align="center">2010</td></tr><tr><td>A1</td><td>A2</td><td>A3</td><td>Total</td><td>A1</td><td>A2</td><td>A3</td><td>Total</td><td>A1</td><td>A2</td><td>A3</td><td
style="width: 28px">Total</td></tr>
<tr>
<td rowspan="2">
JAN</td>
<td rowspan="1">
SALES</td>
<td>
-422976806.00</td>
<td>
-3807391165.06</td>
<td>
0.00</td>
<td>
-4230367971.06</td>
<td>
-18595059667.66</td>
<td>
47537164177.41</td>
<td>
0.00</td>
<td>
28942104509.75</td>
<td>
-982334530.00</td>
<td>
-4036020530.00</td>
<td>
0.00</td>
<td >
-5018355060.00</td>
</tr>
<tr>
<td rowspan="1">
PROFIT</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td rowspan="1">
FEB</td>
<td rowspan="1">
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
</thead><tbody /></table>
</body>
</html>
Regards,
Ramesh
--~------------------------------------------------------------------
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>
--~--