xsl-list
[Top] [All Lists]

XSL-Grouping data

2002-11-11 21:00:11
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



<Prev in Thread] Current Thread [Next in Thread>
  • XSL-Grouping data, Anupama Malla <=