[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

XSL-Grouping data

Subject: XSL-Grouping data
From: "Anupama Malla" <anupama_malla@xxxxxxxxxxx>
Date: Tue, 12 Nov 2002 04:00:11 +0000
xsl grouping data
Hi All,

I am new in xsl/xml and dont yet know much about the intricacies of xsl programming.I would like to group the following data (please see the xml format) in the form of tables.I have gone through the faq and replies to similar queries but the solutions are somehow not working in my case.Kindly forgive me for my ignorance.
It will be great if somebody could suggest an efficient solution.


Regards,
Anupama

XML:
<?xml version="1.0" encoding="UTF-8"?>
<Report Name="report" Title="report">
<TABLE Columns="10" Name="GeneralView" Title="GeneralView">
<!-- Need to group first at THE level
then at ARE level
and last at PFY level
The data is available at runtime
The data on the screen is displayed in the form of tables(at different levels)


THE
	ARE
		PFY
		Data under PFY
-->

<Row RowType="Heading" Title="GeneralView">
<ColumnHeading Name="THE"></ColumnHeading>
<ColumnHeading Name="ARE"></ColumnHeading>
<ColumnHeading Name="PFY"></ColumnHeading>
<ColumnHeading Name="Heading 1"></ColumnHeading>
<ColumnHeading Name=" "></ColumnHeading>
<ColumnHeading Name="Heading 2"></ColumnHeading>
<ColumnHeading Name="Amount"></ColumnHeading>
<ColumnHeading Name=" "></ColumnHeading>
<ColumnHeading Name=" "></ColumnHeading>
<ColumnHeading Name=" "></ColumnHeading>
</Row>
<Row Name="Instances" RowType="Data">
<TableCell Datatype="string" Name="THE" Pattern="" >USP</TableCell>
<TableCell Datatype="string" Name="ARE" Pattern="" >CUE</TableCell>
<TableCell Datatype="string" Name="PFY" Pattern="" >3423</TableCell>
<TableCell Datatype="string" Name="Heading 1" Pattern="" >3170</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >123</TableCell>
<TableCell Datatype="string" Name="Heading 2" Pattern="" >00:00:00.0</TableCell>
<TableCell Datatype="string" Name="Amount" Pattern="" >182035.38</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >182035.38</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >424226</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >424226</TableCell>
</Row>
<Row Name="Instances" RowType="Data">
<TableCell Datatype="string" Name="THE" Pattern="" >USP</TableCell>
<TableCell Datatype="string" Name="ARE" Pattern="" >CUE</TableCell>
<TableCell Datatype="string" Name="PFY" Pattern="" >2600</TableCell>
<TableCell Datatype="string" Name="Heading 1" Pattern="" >11426</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >123</TableCell>
<TableCell Datatype="string" Name="Heading 2" Pattern="" >00:00:00.0</TableCell>
<TableCell Datatype="string" Name="Amount" Pattern="" >242190.62</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >242190.62</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >424226</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >424226</TableCell>
</Row>
<Row Name="Instances" RowType="Data">
<TableCell Datatype="string" Name="THE" Pattern="" >USP</TableCell>
<TableCell Datatype="string" Name="ARE" Pattern="" >ILEC</TableCell>
<TableCell Datatype="string" Name="PFY" Pattern="" >2600</TableCell>
<TableCell Datatype="string" Name="Heading 1" Pattern="" >311130</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >456</TableCell>
<TableCell Datatype="string" Name="Heading 2" Pattern="" >00:00:00.0</TableCell>
<TableCell Datatype="string" Name="Amount" Pattern="" >848.85</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >848.85</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >561017340.99</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >568800216</TableCell>
</Row>


<Row Name="Instances" RowType="Data">
<TableCell Datatype="string" Name="THE" Pattern="" >USP</TableCell>
<TableCell Datatype="string" Name="ARE" Pattern="" >ILEC</TableCell>
<TableCell Datatype="string" Name="PFY" Pattern="" >4567</TableCell>
<TableCell Datatype="string" Name="Heading 1" Pattern="" >311130</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >456</TableCell>
<TableCell Datatype="string" Name="Heading 2" Pattern="" >00:00:00.0</TableCell>
<TableCell Datatype="string" Name="Amount" Pattern="" >848.85</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >848.85</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >561017340.99</TableCell>
<TableCell Datatype="string" Name=" " Pattern="" >568800216</TableCell>
</Row>
</TABLE>
</Report>









_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail



XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list



Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.