Subject: How to Sort, Group, sub-Total and Total in XSL From: mvictor@xxxxxxxxxx Date: Wed, 22 Nov 2000 12:46:05 -0500 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[no subject], David Carlisle | Thread | RE: How to Sort, Group, sub-Total a, Kay Michael |
RE: XML to XML transformation, Kay Michael | Date | RE: A new XSL Formatter, sara . mitchell |
Month |