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>
- Subject: Re: How to Sort, Group, sub-Total and Total in XSL
- From: "Alex Aguilar" <alex at pasofijo dot com>
- Date: Mon, 4 Dec 2000 11:53:02 -0800
- References: <OFDBC9B33C.0B0DC7F2-ON8525699E.0072742B@net>
- Reply-To: xsl-list at mulberrytech dot com
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