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