[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] 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

---