<-prev [Thread] next-> <-prev [Date] next->
Month Index | List Home

How can I create CROSSTAB ?

Subject: How can I create CROSSTAB ?
From: "David ROBERT" <d.robert@xxxxxxxxx>
Date: Sun, 5 Dec 1999 23:28:18 +0100
Hi all,

I have some records extracted from a db from which I would like to generate
crosstab reports in html via xslt.

xml source:

<service_records>
<Invoice_rec>
<departement>department1</departement>
<servicetype>national carrier</servicetype>
<calls>100</calls>
<charge>1500</charge>
</invoice_rec>
<Invoice_rec>
<departement>department1</departement>
<servicetype>international carrier</servicetype>
<calls>150</calls>
<charge>3000</charge>
</invoice_rec>
<Invoice_rec>
<departement>department2</departement>
<servicetype>national carrier</servicetype>
<calls>110</calls>
<charge>1200</charge>
</invoice_rec>
</service_records>

I would like the following html output, I would like to know how I can make
correct select statement (choose/when/otherwise) on a node content (text or
number).


<html>
<p>department1</p>
<table><tr>
<td>national carrier</td><td>100</td><td>1500</td></tr>
<tr><td>international carrier</td><td>150</td><td>3000</td></tr>
</table>
<p>department2</p>
<table><tr>
<td>national carrier</td><td>110</td><td>1200</td></tr>
</table>
</html>

If someone has already done this? thanks

david


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
Current Thread
<- PreviousIndexNext ->
Attention XSLT API writers, Terris Thread Re: Attention XSLT API writers, David Carlisle
XSLT-Based Websites, Terris Date Re: Attention XSLT API writers, David Carlisle
Month