> Sounds like grouping problem to me. Check Jeni's site for
> ideas how to solve the problem:
> http://www.jenitennison.com/xslt/grouping/index.html
> By the way, after fights with database structure, I came
> to conclusion that it is much simpler to use double
> transforms rather than single one, i.e. to transform the
> original recordset to a "normalized" xml and then use power
> of xsl to transform normalized xml to whatever format you need.
> Is this a common practice when you need to display data from
> database? Is there a better solution?

It hurts the brain far less using this double transform :-)
Far clearer for maintenance as well.

If its not a significant exercise, you could collate it
into an rtf , then use xxx:node-set(rtf) instead of running
it out to a file then doing the seperate transform on that.

HTH DaveP

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list