[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
Keywords