Display multiple tables using XSLT

rameshkumar · March 24th, 2010, 04:19 AM

Dear All,
I have a dataset with more than 1 data table. All data table will have
more than 1 rows. My requirement is to display all data tables in HTML format. So I tried a generic xslt.
Below is my XSLT code which displays headers for each row, instead of displaying headers for each table.
I am using dotnet 2.0. And XSLT Version 1.0. I need HTML output.
Please help to fix this!

My XML data is
<?xml version="1.0" standalone="yes"?>
<Sales>
<DocHead>
<SysID>-2008080800041</SysID>
<WFDocID>0</WFDocID>
</DocHead>
<Line>
<SysID>-2008080800045</SysID>
<ParentSysID>-2008080800041</ParentSysID>
<DocType>51</DocType>
</Line>

<Line>
<SysID>-2008080800046</SysID>
<ParentSysID>-2008080800041</ParentSysID>
<DocType>51</DocType>
</Line>
</Sales>

Attempted XSL code is below.
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:template match="/">
<HTML>
<BODY>
<xsl:for-each select="*/*">
<xsl:variable name="PrevRow" select="name(.)"/>
<Table border="1">
<tr>
<xsl:for-each select="*">
<td>
<xsl:value-of select="local-name()"/>
</td>
</xsl:for-each>
</tr>
<xsl:apply-templates/>

</Table>
</xsl:for-each>
</BODY>
</HTML>
</xsl:template>
<xsl:template match="/*/*">
<xsl:param name="nodeset"/>
<TR>
<xsl:apply-templates />
</TR>
</xsl:template>
<xsl:template match="/*/*/*">
<TD>
<xsl:value-of select="."/>
</TD>
</xsl:template>
</xsl:stylesheet>

Regards,
Ramesh

mrame · March 24th, 2010, 05:54 AM

Post the output xml you need from your input xml

rameshkumar · March 24th, 2010, 05:59 AM

I need HTML tables as output.

mrame · March 24th, 2010, 06:06 AM

I did not ask yo about the output format. I asked you about the actual html output you need, like the one below:

Code:

<HTML>
   <BODY>
      <Table border="1">
         <tr>
            <td>SysID</td>
            <td>WFDocID</td>
         </tr>
         <TD>-2008080800041</TD>
         <TD>0</TD>
      </Table>
   </BODY>
</HTML>
...

I know the above html is not what you want, so post the actual html output you require.

rameshkumar · March 24th, 2010, 06:53 AM

The HTML output should be like....
<HTML><BODY>
<Table>
<TR><TD>
<Table border="1">
<tr><td>SysID</td><td>WFDocID</td></tr>
<tr><td>-2008080800041</td><td>0</td></tr>
</Table>
</TD></TR>
<TR><TD> </TD></TR>
<TR><TD>
<Table border="1">
<tr><td>SysID</td><td>ParentSysID</td></tr>
<tr><td>-2008080800045</td><td>-2008080800041</td></tr>
<tr><td>-2008080800046</td><td>-2008080800041</td></tr>
</Table>
</TD></TR>
</Table>
</Body>
</HTML>