RE: Difficult Grouping/Matching problem

BY the way, I am using .NET XslTransform.

-----Original Message-----
From: Kenny Akridge [mailto:kenny@xxxxxxxxxxxxxxxxx] 
Sent: Friday, March 26, 2004 4:05 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Difficult Grouping/Matching problem

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.