[xsl] Generating dynamic HTML table content - headers and cell data

[smithbm33 <smithbm33@xxxxxxxxx>]

I have the following example of XML that I need to
transform into an HTML table. 

Requirements are: 

The HTML table could be have different column headers
each time it is generated based on the incoming XML -
they are comprised of the two static columns (@time
and @stage) then dynamically based on @type. 
Additionally the contents of the rows would be based
on potential groupings of data contained within the
nodes with the context drivers being @stage and @time
within the measurement node (see the second row of the
table below).

I am able to create the table with out the special
logic using XSLT - but this is where I am at a loss
for what XSLT may or may not be able to provide to
perform the additional groupings ang merging, etc..

Thanks in advance...


Here is the XML:

<hemoDynamicTables>
  <cardiacOutput>
    <cardiacOutputTime1>
      <measurement stage="Pre" time="12:01" type="CO"
uom="L/m">4.0</measurement>
      <measurement stage="Pre" time="12:02" type="O2"
uom="%">98</measurement>
      <measurement stage="Post" time="12:05" type="O2"
uom="%">88</measurement>
      <measurement stage="During" time="12:04"
type="SpO2" uom="%">40</measurement>
      <measurement stage="Pre" time="12:02 "
type="xyz" uom="ml">300</measurement>
      <measurement stage="During" time="12:02"
type="He" uom="%">100</measurement>
    </cardiacOutputTime1>
  </cardiacOutput>
</hemoDynamicTables>

The HTML table output that I need is:

Time  | Stage | CO  | O2 | SpO2 | He  | xyz |
---------------------------------------------
12:01 | Pre   | 4.0 |    |      |     |     |
---------------------------------------------
12:02 | Pre   |     | 98 |      |     | 300 |
---------------------------------------------
12:02 | During|     |    |      | 98  |     |
---------------------------------------------
12:04 | During|     |    | 40   |     |     |
---------------------------------------------
12:05 | Post  |     | 88 |      |     |     |
---------------------------------------------

Thanks - Bret


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com