hi,

I am trying to render this xml so it looks like the way I want it in HTML but I can't get anywhere with this. Could anyone be kind enough to help me figure out how to do this? At this point I am lost :(

XML:

<records>
<customer>
<id>1</id>
<name>tom</name>
<city>broon</city>
<amnt>10</amnt>
<state>sc</state>
<section>cc</section>
<recipt>ok</recipt>
</customer>

<customer>
<id>2</id>
<name>john</name>
<city>philly</city>
<amnt>50</amnt>
<state>pa</state>
<section>dd</section>
<recipt>ok</recipt>
</customer>

<customer>
<id>3</id>
<name>phil</name>
<city>dallas</city>
<amnt>100</amnt>
<state>tx</state>
<section>cc</section>
<recipt>ok</recipt>
</customer>

<customer>
<id>4</id>
<name>julian</name>
<city>menphis</city>
<amnt>133</amnt>
<state>sc</state>
<section>cc</section>
<recipt>ok</recipt>
</customer>

<customer>
<id>5</id>
<name>gloria</name>
<city>menphis</city>
<amnt>33</amnt>
<state>sc</state>
<section>dd</section>
<recipt>ok</recipt>
</customer>
</records>

and this is what I want the result to look like:

STATE: SC

SECTION: CC
ID Name Amount City Rec.PT.
1 tom 10 broon ok
4 julian 133 menphis ok

SECTION: DD
ID Name Amount City Rec.PT.
5 gloria 33 menphis ok

STATE: PA

SECTION: DD
ID Name Amount City Rec.PT.
2 John 50 philly ok

STATE: TX

SECTION: DD
ID Name Amount City Rec.PT.
3 phil 100 dallas ok

Looks like a standard grouping problem. Use xsl:for-each-group in XSLT 2.0, or learn about Muenchian grouping at http://www.jenitennison.com/xslt/grouping

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference