|
[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
RE: group data in XSL
Subject: RE: group data in XSL
From: "Vasu Chakkera" <vasucv@xxxxxxxxxxx>
Date: Wed, 18 Aug 2004 16:42:05 +0000
|
If you belong to the Microsoft Family, that pronounced non acceptance of
XSLT2,
or using XSLT processor that doesnt yet support XSLT 2, then here is a
solution using XSLT1.0
It works,
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key match="/dsWMSRpt/WMSReport" name="report-unit"
use="ReportUnitTitle"/>
<xsl:output method="text"/>
<xsl:template match="/">
<xsl:for-each select =
"/dsWMSRpt/WMSReport[generate-id(.)=generate-id(key('report-unit',ReportUnitTitle)[1])]">
<xsl:variable name = "unit" select = "ReportUnitTitle"/>
<xsl:text>Administration Code: </xsl:text>
<xsl:value-of select =
"/dsWMSRpt/WMSReport/AdministrationCode/text()"/>
<xsl:text>
</xsl:text>
<xsl:text>Report Title: </xsl:text>
<xsl:value-of select = "$unit"/>
<xsl:text>
</xsl:text>
<xsl:for-each select = "key('report-unit',$unit)">
<xsl:text>Position Number:</xsl:text>
<xsl:value-of select = "PositionNumber/text()"/>
<xsl:text>
</xsl:text>
</xsl:for-each>
<xsl:text>
</xsl:text>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Note. Please make sure ur ReportUnit node has values as suggested by
Andrew...
HTH
Vasu
From: Tham Tinh <khautinh@xxxxxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: XSL List <XSL-List@xxxxxxxxxxxxxxxxxxxxxx>
Subject: group data in XSL
Date: Wed, 18 Aug 2004 07:48:41 -0700 (PDT)
Hi all,
I have the following data and I would like to group
them please help.
<?xml version="1.0" standalone="yes"?>
<dsWMSRpt>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>Financial
Div/Headquarters</ReportUnitTitle>
<PositionNumber> 0934</PositionNumber>
</WMSReport>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>Part Div</ReportUnitTitle>
<PositionNumber> 4563</PositionNumber>
</WMSReport>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>Financial Div</ReportUnitTitle>
<PositionNumber> K948</PositionNumber>
</WMSReport>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>Human Resource
Div</ReportUnitTitle>
<PositionNumber> 6453</PositionNumber>
</WMSReport>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>HumanResource Div</ReportUnitTitle>
<PositionNumber> 9655</PositionNumber>
</WMSReport>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>Sale Div</ReportUnitTitle>
<PositionNumber> SDWE</PositionNumber>
</WMSReport>
<WMSReport>
<AdministrationCode>ABC</AdministrationCode>
<ReportUnitTitle>Sale Div</ReportUnitTitle>
<PositionNumber> 4577</PositionNumber>
</WMSReport>
</dsWMSRpt>
Now I would like the output to group as following
Administration Code: ABC
Report Title: Financial Div
Position Number: 0934
Position Number: K948
Administration Code: ABC
Report Title: Part Div
Position Number: 4563
Administration Code: ABC
Report Title: Sale Div
Position Number: SDWE
Position Number: 4577
Administration Code: ABC
Report Title: Human Resource Div
Position Number: 6453
Position Number: 9655
=====
"It is essential to know that to be a happy person, a happy family, a happy
society, it is very crucial to have a good heart, that is very crucial,"
Dalai Lama
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!
http://toolbar.msn.co.uk/
 |
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
