This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: How to Sort, Group, sub-Total and Total in XSL
- To: "'xsl-list at mulberrytech dot com'" <xsl-list at mulberrytech dot com>
- Subject: RE: How to Sort, Group, sub-Total and Total in XSL
- From: "Pendakur, Ramesh" <ramesh dot pendakur at intel dot com>
- Date: Mon, 4 Dec 2000 12:43:00 -0800
- Reply-To: xsl-list at mulberrytech dot com
You can also check out www.jenitennison.com for some excellent discussion
and
examples of grouping.
-Ramesh Pendakur
-----Original Message-----
From: Alex Aguilar [mailto:alex@pasofijo.com]
Sent: Monday, December 04, 2000 11:53 AM
To: xsl-list@mulberrytech.com
Subject: Re: How to Sort, Group, sub-Total and Total in XSL
Check out:
http://www.dpawson.co.uk/xsl/N6280.html - Sorting and Grouping
http://www.dpawson.co.uk/xsl/N4486.html - Grouping
----- Original Message -----
From: <mvictor@cms400.com>
To: <XSL-List@mulberrytech.com>
Sent: Wednesday, November 22, 2000 9:46 AM
Subject: How to Sort, Group, sub-Total and Total in XSL
> Hello,
> I'm fairly new to XSL and I would like to produce results similar to
> the following:
>
> Product Based XSL:
>
> Product Id: AAA
> Invoice #: 1234 Qty Ordered: 500
> Invoice #: 5678 Qty Ordered: 200
> Total for Product AAA: 700
>
> Product Id: BBB
> Invoice #: 1234 Qty Ordered: 400
> Total for Product BBB: 400
>
> Total Ordered: 1100
>
>
> Invoice Based XSL:
>
> Invoice #: 1234
> Product Id: AAA Qty Ordered: 500
> Product Id: BBB Qty Ordered: 400
> Total for Invoice # 1234: 900
>
> Invoice #: 5678
> Product Id: AAA Qty Ordered: 200
> Total for Invoice # 5678: 200
>
> Total Ordered: 1100
>
>
> Both XSL documents would be based on the same XML document, similar to the
> following:
>
> <order_history>
> <order_information>
> <invoice>1234</invoice>
> <product>AAA</product>
> <qty_ordered>500</qty_ordered>
> </order_information>
>
> <order_information)
> <invoice>5678</invoice>
> <product>AAA</product>
> <qty_ordered>200</qty_ordered>
> </order_information>
>
> <order_information>
> <invoice>1234</invoice>
> <product>BBB</product>
> (qty_ordered>400</qty_ordered>
> </order_information>
> </order_history>
>
> So far, I've been able to sort the XML data in the proper order by using
> <xsl:for-each select="order_information" order-by="product_id"> and the
> appropriate xsl:value-of select statements. I've found examples of how to
> total two fields, but I'm not sure how to perform the required level-break
> logic for the subtotals within XSL.
>
> Can something like this be done with XSL? I'm using Vendor: Microsoft
> Processor version: Original IE5 (or old version of other processor)
>
> Thanks in advance for any help.
>
>
>
>
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list