RE: [xsl] Conditionally create an html table based upon existance of one or two node sets

Subject: RE: [xsl] Conditionally create an html table based upon existance of one or two node sets
From: Rod Kane <rkane@xxxxxxxxxxxxxxxxxx>
Date: Tue, 30 Mar 2010 14:12:16 -0400
Thanks Robby,

That makes sense to remove the for-each.

The table is still displaying as before though

Rod

-----Original Message-----
From: Robby Pelssers [mailto:robby.pelssers@xxxxxxxxx]
Sent: Tuesday, March 30, 2010 2:12 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] Conditionally create an html table based upon existance of
one or two node sets

This template is wrong.  you should remove the <xsl:for-each> around the <TR>
since it already get's called for every BoxDimension it matches,


<xsl:template match="Dimension">
  <xsl:for-each select=".">
    <TR   BGCOLOR="D3D3D3" >
      <TD width="65%">     <xsl:value-of select="./@Name" />        </TD>
      <TD>                 <xsl:value-of select="../../@Name" />    </TD>
    </TR>
  </xsl:for-each>
</xsl:template>


Cheers,
Robby
-----Original Message-----
From: Rod Kane [mailto:rkane@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, March 30, 2010 8:02 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] Conditionally create an html table based upon existance of one
or two node sets




Hello,

I need to create a table if either the second and third "apply-template"
 directives return nodes, and otherwise create nothing .

 "Fiscal Year" is the Dimension name and C02 and C09 are the "Column Group
Name"s, but the table creation is not quite correct as the rows are not
displayed correctly.

Thank you in advance.

Rod



<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
 
<xsl:template match="/">
<HTML>
<BODY>
       <xsl:apply-templates select="Template"/>
       <xsl:apply-templates
select="Template/Queries/DataQuery/Abstract/Columns/Groups/Group/Dimensions/D
imension[count(*) = 0]"/>
       <xsl:apply-templates
select="Template/Queries/DataQuery/Abstract/Rows/Groups/Group/Dimensions/Dime
nsion[count(*) = 0]"/>
</BODY>
</HTML>
</xsl:template>


<xsl:template match="Template">
       <B>    Template Name:       <xsl:value-of select="@Name" />         
</B>
       <BR/><BR/>

       <xsl:choose>
              <xsl:when
test="./Queries/DataQuery/Abstract/Columns|Rows/Groups/Group/Dimensions/Dimen
sion[count(*) = 0]">

                     <TABLE BORDER="1"  width="85%" >
                           <TR   BGCOLOR="D3D3D3" >
                                  <TD width="65%">     <xsl:text>Dimension
Name</xsl:text>             </TD>
                                  <TD>                 <xsl:text>Column Group
Name</xsl:text>   </TD>
                           </TR>
                     </TABLE>

                     </xsl:when>
       </xsl:choose>

</xsl:template>




<xsl:template match="Dimension">
                    
                     <xsl:for-each select=".">
                           <TR   BGCOLOR="D3D3D3" >
                                  <TD width="65%">     <xsl:value-of
select="./@Name" />        </TD>
                                  <TD>                 <xsl:value-of
select="../../@Name" />    </TD>
                           </TR>
                     </xsl:for-each>

</xsl:template>


</xsl:stylesheet>







Input:

<Template Name="Report" >
  <Queries>
    <DataQuery Name="Suppressed" >
      <Abstract>
        <Columns>
          <Groups>
            <Group Name="C02" >
              <Dimensions>
                <Dimension Name="Fiscal Year">
                </Dimension>
                <Dimension Name="Version">
                  <Conditions/>
                </Dimension>
              </Dimensions>
            </Group>
            <Group Name="C03">
              <Dimensions>
                             <Dimension Name="Fiscal Year">
                                    <Conditions/>
                             </Dimension>
                             <Dimension Name="Version">
                                    <Conditions/>
                             </Dimension>
                                  </Dimensions>
            </Group>
            <Group Name="C09">
              <Dimensions>
                <Dimension Name="Fiscal Year">
                </Dimension>
                <Dimension Name="Version">
                  <Conditions/>
                </Dimension>
              </Dimensions>
            </Group>
          </Groups>
        </Columns>
        <Rows Suppression="true">
          <Dimensions>
            <Dimension Name="Metric" />
          </Dimensions>
          <Groups>
            <Group Name="R1">
              <Dimensions>
                <Dimension Name="Metric">
                </Dimension>
              </Dimensions>
            </Group>
          </Groups>
        </Rows>
      </Abstract>
    </DataQuery>
  </Queries>
</Template>





Output:


Template Name: Report
Dimension Name
Column Group Name
Fiscal Year C02 Fiscal Year C09 Metric R1

Current Thread