XML/XSLT Display Recursive Node

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • pr33tz
    New Member
    • Jul 2006
    • 3

    XML/XSLT Display Recursive Node

    Hi all,

    I have the following XSL file:


    <xsl:template match="/">
    <HTML>
    <BODY>
    <font face="Arial" size="4">Purcha se Order Details</font>
    <xsl:apply-templates />
    </BODY>
    </HTML>
    </xsl:template>
    <xsl:template match="/por:Orders">
    <TABLE WIDTH="100%" BORDER="0" CELLSPACING="1" CELLPADDING="1" >
    <TR bgcolor="#6090C F" >
    <TD STYLE="fontface :Arial"><font color="white">< CENTER><STRONG> User</STRONG></CENTER></font></TD>
    <TD STYLE="fontface :Arial"><font color="white">< CENTER><STRONG> Authorisor</STRONG></CENTER></font></TD>
    <TD STYLE="fontface :Arial"><font color="white">< CENTER><STRONG> Workgroup</STRONG></CENTER></font></TD>
    <TD STYLE="fontface :Arial"><font color="white">< CENTER><STRONG> OrderNo</STRONG></CENTER></font></TD>
    <TD STYLE="fontface :Arial"><font color="white">< CENTER><STRONG> Seq</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> Supplier</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> Value</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> Tax Code</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> Tax Value</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> GL Code</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> Product</STRONG></CENTER></font></TD>
    <TD><font face="Arial" size="2" color="white">< CENTER><STRONG> Desc</STRONG></CENTER></font></TD>
    </TR>

    <xsl:for-each select="por:Ord er">
    <TR bgcolor="LightG reen">
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Use rName"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Aut horisor"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Wor kgroup"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Ord erNo"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Ord erNoSeq"/></font>
    </TD>
    </TR>
    </xsl:for-each>

    <xsl:for-each select="por:Ord er/por:Item">
    <TR bgcolor="LightG reen">
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Sup plierCode"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Val ue"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Tax Code"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Tax Value"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:GLC ode"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por:Ite mCode"/></font>
    </TD>
    <TD>
    <font face="Arial" size="2"><xsl:v alue-of select="por: Description"/></font>
    </TD>
    </TR>
    </xsl:for-each>
    </TABLE>
    </xsl:template>
    </xsl:stylesheet>

    for the following XML file structure:

    <Orders>
    <Order>
    <UserName, Workgroup etc>
    <Item>
    <SupplierCode , TaxValue etc>
    </Item>
    <Item>
    <SupplierCode , TaxValue etc>
    </Item>
    </Order>
    <Order>
    <UserName, Workgroup etc>
    <Item>
    <SupplierCode , TaxValue etc>
    </Item>
    <Item>
    <SupplierCode , TaxValue etc>
    </Item>
    </Order>
    </Orders>

    The problem I'm facing is the way HTML is displayed. I can't get the hierarchy displayed correctly. I've attached a jpeg to kind of illustrate how i'd like the data displayed (if possible).

    I'd appreciate any help/guidance in overcoming this frustrating problem.

    Thanks!!
    Attached Files
Working...