xsl-list
[Top] [All Lists]

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

2010-03-30 13:02:58



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/Dimension[count(*)
 = 0]"/>
       <xsl:apply-templates 
select="Template/Queries/DataQuery/Abstract/Rows/Groups/Group/Dimensions/Dimension[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/Dimension[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





--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--