Hi all,

I've only recently started using XML with XSL and i've got what hopefully should be an easy question.

I have a dataset in my asp.net application which contains a table of data.

The data consists of Owners, a number of possible job status' and the number of jobs at the given status.

The output in SQL looks like so:

Owner, Status, Total
Bob, Unknown, 2
Bob, Known, 4
Bob, Verified, 1
Fred, Known, 3
Fred, Verified, 3
.....

and so on. The grouping is on the employee and then the status and a count is calculated.

I have an XSL template that i want to use to display this data. the part i'm interested in looks:
Code:
        <TABLE>
          <COLGROUP WIDTH="130" ALIGN="LEFT"></COLGROUP>
          <COLGROUP WIDTH="100" ALIGN="LEFT"></COLGROUP>
          <COLGROUP WIDTH="100" ALIGN="LEFT"></COLGROUP>
          <TR>
			<TD CLASS="HDR">Owner</TD>
			<TD CLASS="HDR">Status</TD>
			<TD CLASS="HDR">Total</TD>
          </TR>
          <xsl:for-each select="IssuesByStatus/Table1">
            <TR>
			<TD><xsl:value-of select="Owner"/></TD>
				<TD><xsl:value-of select="Status"/></TD>
              <TD><xsl:value-of select="Total"/></TD>
            </TR>
          </xsl:for-each>
        </TABLE>
The problem I'm having is that the output repeats the Owner for each status. as shown in the example above. I'd like to be able (using XSL if possible) to only show the Owner name once for each group of status'.

Is this possible and if so how would i go about doing that.

Many thanks in advance

Grant