xsl-list
[Top] [All Lists]

RE: Multiple groupings

2004-04-27 06:46:16
Ken,

I am outputting this data to html.  When I use this XSL:

<xsl:template match="ArrayOfAccountLineItem">
                <!-- CAPTURE ALL AccountLineItem NODES IN A VARIABLE -->
                <xsl:variable name="items"
select="/ArrayOfAccountLineItem/AccountLineItem"/>
                <!-- LOOP THROUGH ALL AccountLineItems -->
                <xsl:for-each select="$items">
                        <!-- IF THE CONTEXT NODE IS THE FIRST NODE IN THE
TREE WITH THE CONTEXT PaymentType -->
                        <xsl:if test="generate-id(.) =
generate-id($items[PaymentType=current()/PaymentType])">
                                <!-- CAPTURE ALL NODES WITH A MATCHING
PaymentType -->
                                <xsl:variable name="payments"
select="$items[PaymentType=current()/PaymentType]"/>
                                <xsl:value-of select="PaymentType"/><br/>
                                <!-- LOOP THROUGH ALL NODES WITH MATCHING
PaymentType -->
                                <xsl:for-each select="$payments">
                                        <!-- IF THE CONTEXT NODE IS THE
FIRST NODE IN THE TREE WITH THE CONTEXT CityName -->
                                        <xsl:if test="generate-id(.) =
generate-id($payments[CityName=current()/CityName])">
                                                <xsl:value-of
select="CityName"/><br/>
                                                <!-- LOOP THROUGH ALL NODES
WITH MATCHING CityName -->
                                                <xsl:for-each
select="$payments[CityName=current()/CityName]">
                                                        <xsl:apply-templates
select=".">
        
<xsl:with-param name="count" select="position()"/>
        
</xsl:apply-templates>
                                                </xsl:for-each>
                                        </xsl:if>
                                </xsl:for-each>
                        </xsl:if>
                </xsl:for-each>
        </xsl:template>

I am getting all of the PaymentType and CityName at the very top of the
report.  Then I get all of the records sequentially below that.  How can I
break the record listing and subtitle each section?  It worked fine in the
text version.  For totaling, should I just use keys?

Thanks again,
Kenny Akridge

-----Original Message-----
From: G. Ken Holman [mailto:gkholman(_at_)CraneSoftwrights(_dot_)com] 
Sent: Tuesday, April 27, 2004 7:03 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Multiple groupings

At 2004-04-27 00:13 -0400, Kenny Akridge wrote:
I basically have XML that has a PaymentType, City, Date and ID.  I
need to group all records by PaymentType then by City.

I find multi-level grouping is most easily solved using variable-based 
grouping.

I need to total by city and by Payment type.

I don't see any numbers to be totalled in your XML.

Any thoughts on the best way to tackle this?

Below is a working example with your data.  Note how I use variables to 
capture the subset of the document in which I need to do grouping, so that 
I don't always have to deal with document-wide scope.

I hope this helps.

...................... Ken

t:\ftemp>type akridge.xml
<?xml version="1.0" encoding="UTF-8"?>
<ArrayOfAccountLineItems>
         <AccountLineItem>
                 <ID>12993</ID>
                 <PaymentType>Credit Card</PaymentType>
                 <SettleDate>2004-04-14T22:57:46.6230000-04:00</SettleDate>
                 <CityName>Las Vegas</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12992</ID>
                 <PaymentType>Cash</PaymentType>
                 <SettleDate>2004-04-14T22:57:46.6230000-04:00</SettleDate>
                 <CityName>New York</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12963</ID>
                 <PaymentType>Check</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.3100000-04:00</SettleDate>
                 <CityName>Orlando</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12962</ID>
                 <PaymentType>Check</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.3100000-04:00</SettleDate>
                 <CityName>New York</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12969</ID>
                 <PaymentType>Credit Card</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.4830000-04:00</SettleDate>
                 <CityName>Las Vegas</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12968</ID>
                 <PaymentType>Voucher</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.4830000-04:00</SettleDate>
                 <CityName>Orlando</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12975</ID>
                 <PaymentType>Check</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.6400000-04:00</SettleDate>
                 <CityName>Las Vegas</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12974</ID>
                 <PaymentType>Check</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.6400000-04:00</SettleDate>
                 <CityName>Orlando</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12981</ID>
                 <PaymentType>Voucher</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.8100000-04:00</SettleDate>
                 <CityName>New York</CityName>
         </AccountLineItem>
         <AccountLineItem>
                 <ID>12980</ID>
                 <PaymentType>Cash</PaymentType>
                 <SettleDate>2004-04-14T22:57:51.8100000-04:00</SettleDate>
                 <CityName>Orlando</CityName>
         </AccountLineItem>
</ArrayOfAccountLineItems>


t:\ftemp>type akridge.xsl
<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                 version="1.0">

<xsl:output method="text"/>

<xsl:template match="/">
   <xsl:variable name="items"
                 select="/ArrayOfAccountLineItems/AccountLineItem"/>
   <xsl:for-each select="$items">
     <xsl:if test="generate-id(.)=
                   generate-id($items[PaymentType=current()/PaymentType])">
       <xsl:variable name="payments"
                     select="$items[PaymentType=current()/PaymentType]"/>
       <xsl:text/>Payments for '<xsl:value-of select="PaymentType"/>':
<xsl:text/>
       <xsl:for-each select="$payments">
         <xsl:if test="generate-id(.)=
                       generate-id($payments[CityName=current()/CityName])">
           <xsl:text/>  In city '<xsl:value-of select="CityName"/>:
<xsl:text/>
           <xsl:for-each select="$payments[CityName=current()/CityName]">
             <xsl:value-of select="concat('    ID:',ID,'
Date:',SettleDate)"/>
             <xsl:text>
</xsl:text>
           </xsl:for-each>
         </xsl:if>
       </xsl:for-each>
     </xsl:if>
   </xsl:for-each>
</xsl:template>

</xsl:stylesheet>
t:\ftemp>saxon akridge.xml akridge.xsl
Payments for 'Credit Card':
   In city 'Las Vegas:
     ID:12993 Date:2004-04-14T22:57:46.6230000-04:00
     ID:12969 Date:2004-04-14T22:57:51.4830000-04:00
Payments for 'Cash':
   In city 'New York:
     ID:12992 Date:2004-04-14T22:57:46.6230000-04:00
   In city 'Orlando:
     ID:12980 Date:2004-04-14T22:57:51.8100000-04:00
Payments for 'Check':
   In city 'Orlando:
     ID:12963 Date:2004-04-14T22:57:51.3100000-04:00
     ID:12974 Date:2004-04-14T22:57:51.6400000-04:00
   In city 'New York:
     ID:12962 Date:2004-04-14T22:57:51.3100000-04:00
   In city 'Las Vegas:
     ID:12975 Date:2004-04-14T22:57:51.6400000-04:00
Payments for 'Voucher':
   In city 'Orlando:
     ID:12968 Date:2004-04-14T22:57:51.4830000-04:00
   In city 'New York:
     ID:12981 Date:2004-04-14T22:57:51.8100000-04:00

t:\ftemp>rem Done!



--
Public courses: Spring 2004 world tour of hands-on XSL instruction
Each week:   Monday-Wednesday: XSLT/XPath; Thursday-Friday: XSL-FO

Hong Kong May 17-21; Bremen Germany May 24-28; Helsinki June 14-18

World-wide on-site corporate, govt. & user group XML/XSL training.
G. Ken Holman                 mailto:gkholman(_at_)CraneSoftwrights(_dot_)com
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/s/
Box 266, Kars, Ontario CANADA K0A-2E0    +1(613)489-0999 (F:-0995)
Male Breast Cancer Awareness  http://www.CraneSoftwrights.com/s/bc
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal


--+------------------------------------------------------------------
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>
--+--




<Prev in Thread] Current Thread [Next in Thread>