[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[xsl] display xml to complex html format
Subject: [xsl] display xml to complex html format From: Ramesh Kumar <cnrameshkumar@xxxxxxxxx> Date: Fri, 26 Mar 2010 17:43:52 +0400 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] recursive loop in XSL sty, Wendell Piez | Thread | RE: [xsl] display xml to complex ht, Michael Kay |
RE: [xsl] Calculating Column Total, Shashank Jain | Date | RE: [xsl] display xml to complex ht, Michael Kay |
Month |