XML Editor - Download a Free Trial >
See What's New >
Buy Now >

[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

grouping within a group in XSLT1.0

Play the video
Subject: grouping within a group in XSLT1.0
From: Debbie <debbieannepower@xxxxxxxxx>
Date: Thu, 31 Aug 2006 17:09:41 -0230
fo flow within for each
Hi All,

I need to do a group within a group in XSLT 1.0.  I'm using XALAN to
transform an xml into pdf via FOP 0.20.5.  Here is my problem.

I have an xml document that has a list of questions and their
responses.  These questions are divided up into sections such as
section 1-0-0 and 2-0-0 etc.

What I have to do is bring back a list of unique responses (no
repeats) for the questions in each section and a count for each
response.  The responses can be anything.  So what I need returned is
this:

Section Count

1-0-0
No		3
Yes		2
N/A		1

2-0-0
Not Documented	4
Approved	2
Yes		3

I have tried the meunchian grouping method but couldn't seem to get it
to work. The method I have now fails if there are 3 same responses in
a row.  It puts the first response in the section with the previous
section.  I pretty sure that it's happening because I'm using
preceding and following to check the responses but I can't think of
another way of doing this.  Any suggestions?


My Stylesheet is attached:  This is the section of the attached
stylesheet that returns the unique responses.

<!--brings back unique responses -->

                  <fo:table-cell>
                   <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="2px">
                    <xsl:choose>
                     <xsl:when test="sec_id">
                      <xsl:if test="not(audit_response/resp='')">
                       <xsl:if test="sec_id=$test">										
                        <xsl:for-each
select="audit_response/resp[1][not(.=preceding::audit_response/resp[1])]
| audit_response/resp[1][not(.=following::audit_response/resp[1])]">
                         <xsl:value-of select="."/>
                        </xsl:for-each>
                       </xsl:if>
                      </xsl:if>
                     </xsl:when>
                    </xsl:choose>										
                   </fo:block>							
                  </fo:table-cell>








My Stylesheet:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:date="http://exslt.org/dates-and-times"
xmlns:fo="http://www.w3.org/1999/XSL/Format"
xmlns:xalan="http://xml.apache.org/xalan"
xmlns:java="http://xml.apache.org/xslt/java"
xmlns:exsl="http://exslt.org/common" xmlns:set="http://exslt.org/sets"
xmlns:dyn="http://exslt.org/dynamic" extension-element-prefixes="exsl"
exclude-result-prefixes="set">
	<xsl:output/>

	<xsl:key name="response"
match="report/audit/questions/question/audit_response" use="resp"/>
	<xsl:key name="responseNum" match="report/audit/questions/question"
use="resp_num"/>
	<xsl:key name="car" match="report/audit/questions/question"
use="audit_response/corr_acts/corr_act"/>
	<xsl:key name="response2" match="report/audit/questions/question"
use="audit_response/resp"/>
	<xsl:key name="corracts" match="report/audit/questions/question"
use="audit_response/corr_acts/corr_act/id"/>
	<xsl:key name="keys_sec_id" match="report/audit/questions/question"
use="sec_id"/>
	<xsl:key name="resps" match="//resp" use="resp"/>
	<xsl:template match="/">
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format">

<fo:layout-master-set>
<fo:simple-page-master master-name="rptPages" page-height="10in"
page-width="8in" margin-top="1cm" margin-bottom=".5cm"
margin-left="1cm" margin-right="1cm">
 <fo:region-body margin-bottom="1.5cm" margin-top="2cm"
keep-together.within-page="always">
 </fo:region-body>
  <fo:region-after region-name="rptFooter" extent="1cm"/>
   <fo:region-before region-name="rptHeader" extent="2cm"/>
</fo:simple-page-master>
</fo:layout-master-set>
<fo:page-sequence master-reference="rptPages" force-page-count="no-force">

<!--        REPORT HEADER -->
<fo:static-content flow-name="rptHeader">
<fo:table table-layout="fixed" inline-progression-dimension="18cm"
cell-spacing="0" cell-padding="0">
 <fo:table-column column-width="6cm"/>
  <fo:table-column column-width="9cm"/>
   <fo:table-column column-width="3.5cm"/>
    <fo:table-body>
     <fo:table-row>
      <fo:table-cell>

       <fo:external-graphic width="2.5in" height="0.75in"
src="file:xsl/IATAlogo.jpg" />
      </fo:table-cell>
     </fo:table-row>
      <fo:table-row>
      <fo:table-cell />
     </fo:table-row>
     <fo:table-row>
      <fo:table-cell>
       <fo:block font-size="17pt" font="Arial" font-weight="bold">
<!-- <xsl:value-of select="report/audit/company_name" />-->
       </fo:block>
      </fo:table-cell>
     </fo:table-row>
     <fo:table-row>
      <fo:table-cell>
       <fo:block>
        <xsl:text disable-output-escaping="yes">&amp;#160;</xsl:text>
       </fo:block>
      </fo:table-cell>
     </fo:table-row>
     <fo:table-row>
      <fo:table-cell>
       <fo:block font-size="12pt" font="Arial" font-weight="bold"
space-after="5px">Tally Report</fo:block>
      </fo:table-cell>
     </fo:table-row>
    </fo:table-body>
   </fo:table>
  </fo:static-content>
<!-- End of header section.  Beginning of page footer -->
<fo:static-content flow-name="rptFooter">
<fo:block font-size="9pt" font-weight="normal">
 <fo:table table-layout="fixed" inline-progression-dimension="18cm"
cell-spacing="0" cell-padding="0">
  <fo:table-column column-width="4cm"/>
   <fo:table-column column-width="7.5cm"/>
    <fo:table-column column-width="2cm"/>
     <fo:table-column column-width="2cm"/>
      <fo:table-body>
       <fo:table-row>
        <fo:table-cell>
         <fo:block>
          <xsl:text disable-output-escaping="yes">&amp;#160;</xsl:text>
         </fo:block>
        </fo:table-cell>
       </fo:table-row>
       <fo:table-row>
        <fo:table-cell>
         <fo:block font-size="9pt" font="Arial" font-weight="normal"
text-align="left">
          <xsl:variable name="date">
           <xsl:value-of select="date:date-time()"/>
            </xsl:variable>
             <xsl:value-of select="substring($date,1,10)"/>
           </fo:block>
          </fo:table-cell>
          <fo:table-cell>
           <fo:block font="Arial" text-align="center" font-size="6pt"
font-weight="normal">
            <xsl:value-of select="report/AuditResponse/footerText"/>
          </fo:block>
         </fo:table-cell>
         <fo:table-cell>
          <fo:block font="Arial" text-align="right" font-size="9pt"
font-weight="normal">Page <fo:page-number/>
           / <fo:page-number-citation ref-id="last-page"/></fo:block>
          </fo:table-cell>
         </fo:table-row>
        </fo:table-body>
       </fo:table>
      </fo:block>
     </fo:static-content>
<!-- beginning of region body and beginning of Page Header information-->
<fo:flow flow-name="xsl-region-body">
<fo:table table-layout="fixed" inline-progression-dimension="18cm"
cell-spacing="0" cell-padding="0">
 <fo:table-column column-width="6cm"/>
  <fo:table-column column-width="9cm"/>
   <fo:table-column column-width="3.5cm"/>
    <fo:table-body>
     <fo:table-row>
      <fo:table-cell>
       <fo:block font="Arial" font-size="9pt"
font-weight="bold">Customer:</fo:block>
       </fo:table-cell>
       <fo:table-cell>
        <fo:block font="Arial" font-size="9pt">
         <xsl:value-of select="report/audit/customername"/>
         </fo:block>
        </fo:table-cell>
       </fo:table-row>
        <fo:table-row>
         <fo:table-cell>
          <fo:block font-size="9pt" font="Arial"
font-weight="bold">Audit Location:</fo:block>
         </fo:table-cell>
          <fo:table-cell>
           <fo:block font="Arial" font-size="9pt">
            <xsl:value-of select="report/audit/levelstring"/>
           </fo:block>
          </fo:table-cell>
         </fo:table-row>
          <fo:table-row>
           <fo:table-cell>
            <fo:block font-size="9pt" font="Arial"
font-weight="bold">Audit Name:</fo:block>
           </fo:table-cell>
            <fo:table-cell>
             <fo:block font="Arial" font-size="9pt">
              <xsl:value-of select="report/audit/auditname"/>
             </fo:block>
            </fo:table-cell>
           </fo:table-row>
            <fo:table-row>
             <fo:table-cell>
              <fo:block font="Arial" font-size="9pt"
font-weight="bold">Audit Date:</fo:block>
             </fo:table-cell>
              <fo:table-cell>
               <fo:block font="Arial" font-size="9pt">
                <xsl:value-of select="report/audit/audit_date"/>
               </fo:block>
              </fo:table-cell>
             </fo:table-row>
              <fo:table-row>
               <fo:table-cell>
                <fo:block font-size="9pt" font="Arial"
font-weight="bold">User Account:</fo:block>
               </fo:table-cell>
                <fo:table-cell>
                 <fo:block font="Arial" font-size="9pt">
                  <xsl:value-of select="report/audit/user_name"/>
                </fo:block>
               </fo:table-cell>
              </fo:table-row>
               <fo:table-row>
                <fo:table-cell number-columns-spanned="4">
                 <fo:block border-bottom-style="solid"
border-top-style="thin" border-bottom-color="#000000"
border-top-color="#000000" border-bottom-width="thin"
border-top-width="thin" space-after="6px">
                  </fo:block>
                 </fo:table-cell>
                </fo:table-row>
                 <fo:table-row/>
                 <fo:table-row/>
           </fo:table-body>
   </fo:table>
   <!-- beginning of test section -->

   <fo:table table-layout="fixed" inline-progression-dimension="18cm"
cell-spacing="0" cell-padding="0">
    <fo:table-column column-width="8cm"/>
     <fo:table-column column-width="1cm"/>
      <fo:table-column column-width="2cm"/>
       <fo:table-column column-width="1.5cm"/>
        <fo:table-column column-width=".1cm"/>
         <fo:table-column column-width="1.5cm"/>
          <fo:table-body>
           <fo:table-row>
            <fo:table-cell>
             <fo:block font="Arial" text-align="left"
font-size="10pt" font-weight="bold" space-after="6px">
               Sections
             </fo:block>
            </fo:table-cell>

            <fo:table-cell>
             <fo:block font="Arial" text-align="center"
font-size="10pt" font-weight="bold" space-after="6px">
               List #
             </fo:block>
            </fo:table-cell>

            <fo:table-cell>
             <fo:block font="Arial" text-align="center"
font-size="10pt" font-weight="bold" space-after="6px">
               Response
             </fo:block>
            </fo:table-cell>

             <fo:table-cell>
              <fo:block font="Arial" text-align="center"
font-size="10pt" font-weight="bold" space-after="6px">
               Tally
              </fo:block>
              </fo:table-cell>
              <fo:table-cell/>

              <fo:table-cell>
              <fo:block font="Arial" text-align="center"
font-size="10pt" font-weight="bold" space-after="6px">
               CAR
              </fo:block>
             </fo:table-cell>
            </fo:table-row>
           </fo:table-body>
          </fo:table>


<fo:table table-layout="fixed" inline-progression-dimension="18cm"
cell-spacing="0" cell-padding="0">
<fo:table-column column-width="8cm"/>
 <fo:table-column column-width="1cm"/>
  <fo:table-column column-width="2cm"/>
   <fo:table-column column-width="1.5cm"/>
    <fo:table-column column-width=".1cm"/>
     <fo:table-column column-width="1.5cm"/>
      <fo:table-body>
       <xsl:for-each select="report/audit/questions/question">
        <xsl:sort data-type="number" select="sec_id"/>
         <xsl:sort data-type="number" select="sec_id"/>
          <xsl:sort data-type="number" select="sub_sec_id"/>
           <xsl:sort data-type="number" select="item_id"/>
            <fo:table-row>
             <xsl:choose>
              <xsl:when test="sec_id">
               <xsl:variable name="test" select="sec_id"/>
                <xsl:if test="(sec_id &gt;=0) and sub_sec_id=0 and item_id=0 ">
                 <fo:table-cell>
                  <fo:block font="Arial" text-align="left"
font-size="8pt" font-weight="normal" space-after="2px">
                   <xsl:value-of select="sec_id"/>-<xsl:value-of
select="sub_sec_id"/>-<xsl:value-of select="item_id"/>
                    <xsl:text
disable-output-escaping="yes">&amp;#160;&amp;#160;&amp;#160;</xsl:text>
                     <xsl:value-of select="itemdescription"/>
                   </fo:block>
                  </fo:table-cell>
                 </xsl:if>


<!-- brings back a unique response number -->
                <fo:table-cell />
                 <fo:table-cell >
                  <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="2px">
                   <xsl:if test="not(sec_id &gt;=0 and sub_sec_id
&gt;=0 and item_id=0)">
                    <xsl:if test="sec_id=$test">
                     <fo:block></fo:block>
                      <xsl:if test="not(audit_response/resp='')">
                       <xsl:for-each
select="audit_response/resp[1][not(.=preceding::audit_response/resp[1])]
| audit_response/resp[1][not(.=following::audit_response/resp[1])]">
                        <xsl:value-of select="../../resp_num"/>
                       </xsl:for-each>
                      </xsl:if>
                     </xsl:if>
                    </xsl:if>
                   </fo:block>
                  </fo:table-cell>
<!--brings back unique responses -->

                  <fo:table-cell>
                   <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="2px">
                    <xsl:choose>
                     <xsl:when test="sec_id">
                      <xsl:if test="not(audit_response/resp='')">
                       <xsl:if test="sec_id=$test">										
                        <xsl:for-each
select="audit_response/resp[1][not(.=preceding::audit_response/resp[1])]
| audit_response/resp[1][not(.=following::audit_response/resp[1])]">
                         <xsl:value-of select="."/>
                        </xsl:for-each>
                       </xsl:if>
                      </xsl:if>
                     </xsl:when>
                    </xsl:choose>										
                   </fo:block>							
                  </fo:table-cell>
<!-- brings back a tally of the responses -->

                 <xsl:variable name="group"
select="audit_response/resp[1][not(.=preceding::audit_response/resp[1])]
| audit_response/resp[1][not(.=following::audit_response/resp[1])]"/>

                   <fo:table-cell>
                   <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="5px">
                    <xsl:if test="not(sec_id &gt;=0 and sub_sec_id
&gt;=0 and item_id=0)">
                     <xsl:if test="sec_id=$test">
                      <xsl:if test="$group != ''">
                       <xsl:choose> <!--begins the outside choose -->
                        <xsl:when test="sec_id">
                         <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="5px">

                          <xsl:variable name="sec_id" select="sec_id"/>
                           <xsl:value-of
select="count(../question[sec_id =
$sec_id]/audit_response/resp[.=$group])"/>
                          </fo:block>
                         </xsl:when>
                        </xsl:choose>
                       </xsl:if>
                      </xsl:if>
                     </xsl:if>
                    </fo:block>
                   </fo:table-cell>



<!-- brings back a count of the cars per answered question -->

                 <fo:table-cell />
                  <fo:table-cell>
                   <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="2px">
                     <xsl:if test="sec_id=$test">
                      <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="2px">
                       <xsl:variable name="sec_id" select="sec_id"/>
                        <xsl:if test="sec_id=$sec_id">
                         <xsl:if
test="count(audit_response/corr_acts/corr_act/id[not(*)]) &gt;0">
                          <xsl:value-of
select="count(audit_response/corr_acts/corr_act/id[not(*)])"/>
                         </xsl:if>
                        </xsl:if>
                       </fo:block>
                      </xsl:if>
                     </fo:block>
                    </fo:table-cell>
                   </xsl:when>
                  </xsl:choose>
                 </fo:table-row>
                </xsl:for-each>
               </fo:table-body>
              </fo:table>


<fo:table table-layout="fixed" space-before="7px" border="1"
border-style="solid" background-color="#EEEEEE"
inline-progression-dimension="18cm" cell-spacing="0" cell-padding="0">
<fo:table-column column-width="8cm"/>
 <fo:table-column column-width="1cm"/>
  <fo:table-column column-width="2cm"/>
   <fo:table-column column-width="1.5cm"/>
    <fo:table-column column-width="2.5cm"/>
     <fo:table-column column-width=".5cm"/>
      <fo:table-body>
       <fo:table-row>
        <fo:table-cell>
         <fo:block font="Arial" text-align="left" font-size="10pt"
font-weight="bold" space-after="6px">
            Report Summary Totals:
         </fo:block>
        </fo:table-cell>
        <fo:table-cell/>
         <fo:table-cell>
          <fo:block font="Arial" text-align="right" font-size="10pt"
font-weight="bold" space-after="6px">
               Responses
          </fo:block>
         </fo:table-cell>
          <fo:table-cell>
           <fo:block font="Arial" text-align="center"
font-size="10pt" font-weight="bold" space-after="6px">
               Total
           </fo:block>
          </fo:table-cell>
         </fo:table-row>
          <fo:table-row>
           <fo:table-cell/>
          </fo:table-row>
         </fo:table-body>
        </fo:table>
<!-- table to bring back the responses and car tallies-->
<fo:table table-layout="fixed" border="1"  border-style="solid"
background-color="#99FFFF" inline-progression-dimension="18cm"
cell-spacing="0" cell-padding="0">
<fo:table-column column-width="8cm"/>
 <fo:table-column column-width="1cm"/>
  <fo:table-column column-width="2cm"/>
   <fo:table-column column-width="1.5cm"/>
    <fo:table-column column-width="2.5cm"/>
     <fo:table-column column-width=".5cm"/>
      <fo:table-body>
       <fo:table-row>
       <fo:table-cell/>
       <fo:table-cell/>
        <fo:table-cell>
         <fo:block font="Arial" text-align="center" font-size="8pt"
font-weight="normal" space-before = "5px" space-after="2px">
          <xsl:for-each
select="report/audit/questions/question[generate-id() =
generate-id(key('response2',audit_response/resp)[1])]">
           <xsl:if test="not(audit_response/resp='')">
            <fo:block></fo:block>
             <xsl:value-of select="audit_response/resp"/>
            </xsl:if>
           </xsl:for-each>
          </fo:block>
         </fo:table-cell>
          <fo:table-cell>
           <fo:block font="Arial" text-align="center" font-size="8pt"
font-weight="normal" space-after="2px" >
            <xsl:for-each
select="report/audit/questions/question[count(.| key('response2',
audit_response/resp)[1]) = 1]">
             <xsl:if test="not(audit_response/resp='')">
              <fo:block></fo:block>
               <xsl:if
test="not(count(key('response2',audit_response/resp))=0)">
                <xsl:value-of
select="count(key('response2',audit_response/resp))"/>
               </xsl:if>
              </xsl:if>
             </xsl:for-each>
            </fo:block>
           </fo:table-cell>
          </fo:table-row>
           <fo:table-row>
            <fo:table-cell/>
             <fo:table-cell/>
              <fo:table-cell>
               <fo:block font="Arial" text-align="center"
font-size="10pt" font-weight="bold" space-after="6px">
                   CARs
               </fo:block>
              </fo:table-cell>
<!-- brings back a count of the cars per answered question  -->
               <fo:table-cell>
                <fo:block font="Arial" text-align="center"
font-size="8pt" font-weight="normal" space-after="2px">
                 <xsl:choose>
                  <xsl:when test="/report/audit/questions/question">
                   <xsl:if test="not(audit_response/resp='')">
                    <xsl:if test="not(audit_response/corr_acts/corr_act='')">
                     <xsl:if
test="not(audit_response/corr_acts/corr_act/id=0)">
                      <xsl:value-of select="count(//corr_act) div 2"/>
                     </xsl:if>
                    </xsl:if>
                   </xsl:if>
                  </xsl:when>
                 </xsl:choose>
                </fo:block>
               </fo:table-cell>
              </fo:table-row>
<!--end of CAR code -->
            </fo:table-body>
           </fo:table>
           <fo:block id="last-page"/>
         </fo:flow>
        </fo:page-sequence>
       </fo:root>
     </xsl:template>
    </xsl:stylesheet>

Current Thread
<- PreviousIndexNext ->
group within a group, Debbie Thread Re: grouping within a group i, G. Ken Holman
group within a group, Debbie Date Outputting newline to XSL doc, Peterson, Melanie S.
Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
XML Editor - Download a 15 Day Free Trial Now >
See What's New in Stylus Studio >
Buy Stylus Studio - XML Editor - Now >
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.