[xsl] Difficult Grouping/Matching problem

Subject: [xsl] Difficult Grouping/Matching problem
From: "Kenny Akridge" <kenny@xxxxxxxxxxxxxxxxx>
Date: Fri, 26 Mar 2004 16:05:16 -0500
I am trying to list out a number of columns with event dates in a header and
then place an 'X' in the cell that corresponds to the date for attendees of
the events.  
The XML is like this:

<ArrayOfAttendance xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
  <Attendance>
    <FirstName>John</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-10T00:00:00.0000000-05:00</ClassDate>
    <Attend>YES</Attend>
  </Attendance>
  <Attendance>
    <FirstName>John</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-17T00:00:00.0000000-05:00</ClassDate>
    <Attend>NO</Attend>
  </Attendance>
  <Attendance>
    <FirstName>John</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-20T00:00:00.0000000-05:00</ClassDate>
    <Attend>YES</Attend>
  </Attendance>
  <Attendance>
    <FirstName>John</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-24T00:00:00.0000000-05:00</ClassDate>
    <Attend>YES</Attend>
  </Attendance>
  <Attendance>
    <FirstName>Jane</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-10T00:00:00.0000000-05:00</ClassDate>
    <Attend>YES</Attend>
  </Attendance>
  <Attendance>
    <FirstName>Jane</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-17T00:00:00.0000000-05:00</ClassDate>
    <Attend>YES</Attend>
  </Attendance>
  <Attendance>
    <FirstName>Jane</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-20T00:00:00.0000000-05:00</ClassDate>
    <Attend>NO</Attend>
  </Attendance>
  <Attendance>
    <FirstName>Jane</FirstName>
    <LastName>Doe</LastName>
    <ClassDate>2004-01-24T00:00:00.0000000-05:00</ClassDate>
    <Attend>YES</Attend>
  </Attendance>
</ArrayOfAttendance>

I want to produce HTML output like this:

Name		1/10/04	1/17/04
-------------------------------
John Doe	  X		  
Jane Doe	  X		  X

Name		1/20/04	1/24/04
-------------------------------
John Doe	  X		  X
Jane Doe			  X

This is assuming that I can only fit n number of dates on one line for a
printed report.

I am having a difficult time approaching this and I am tempted to give up
using XSL to handle this.

Any thoughts would help.  Thanks.

Current Thread