[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
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.
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)
<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
[xsl] XSL-Grouping data
Subject: [xsl] XSL-Grouping data From: "Anupama Malla" <anupama_malla@xxxxxxxxxxx> Date: Tue, 12 Nov 2002 04:00:11 +0000 |
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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Navigationg thru XML Elem, David Carlisle | Thread | [xsl] Storing calculated values in , Chitra Lalita Madhwa |
Re: [xsl] Using Javascript with XSL, Mike Brown | Date | Re: [xsl] Navigationg thru XML Elem, Joerg Heinicke |
Month |