[xsl] Assistance with hiding duplicate data

Subject: [xsl] Assistance with hiding duplicate data
From: "Garrett Murphy" <gmurphy@xxxxxxxxxxxx>
Date: Thu, 4 Sep 2008 15:53:19 -0400
I've combed these boards over and can't find anything that particularly
helps with this exact issue.

Data:
<report>
   <record>
       <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
       <Case_No>0606-0000000055</Case_No>
       <Current_Status>-</Current_Status>
       <Current_Status_Expires></Current_Status_Expires>
       <Birth_Date>05/27/1971</Birth_Date>
       <Case_Opened>06/14/2006</Case_Opened>
       <Responsible_Attorney>NR</Responsible_Attorney>
   </record>
   <record>
       <Beneficiary_Name>Mexico, Ron</Beneficiary_Name>
       <Case_No>0608-0000000275</Case_No>
       <Current_Status>H-1B</Current_Status>
       <Current_Status_Expires>00/00/00</Current_Status_Expires>
       <Birth_Date>May 26, 19</Birth_Date>
       <Case_Opened>08/23/2006</Case_Opened>
       <Responsible_Attorney>HI</Responsible_Attorney>
   </record>
   <record>
       <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
       <Case_No>0606-0000000055</Case_No>
       <Current_Status>-</Current_Status>
       <Current_Status_Expires>xxxxxxxxxx</Current_Status_Expires>
       <Birth_Date>05/27/1971</Birth_Date>
       <Case_Opened>09/05/2006</Case_Opened>
       <Responsible_Attorney>HI</Responsible_Attorney>
   </record>
   <record>
       <Beneficiary_Name>Mexico, Ron</Beneficiary_Name>
       <Case_No>0608-0000000275</Case_No>
       <Current_Status>H-1B</Current_Status>
       <Current_Status_Expires>00/00/00</Current_Status_Expires>
       <Birth_Date>May 26, 19</Birth_Date>
       <Case_Opened>09/18/2006</Case_Opened>
       <Responsible_Attorney>HI</Responsible_Attorney>
   </record>
   <record>
       <Beneficiary_Name>Mexico, Ron</Beneficiary_Name>
       <Case_No>0608-0000000275</Case_No>
       <Current_Status>H-1B</Current_Status>
       <Current_Status_Expires>00/00/00</Current_Status_Expires>
       <Birth_Date>May 26, 19</Birth_Date>
       <Case_Opened>09/21/2006</Case_Opened>
       <Responsible_Attorney>HI</Responsible_Attorney>
   </record>
   <record>
       <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
       <Case_No>0606-0000000055</Case_No>
       <Current_Status>-</Current_Status>
       <Current_Status_Expires>xxxxxxxxxx</Current_Status_Expires>
       <Birth_Date>05/27/1971</Birth_Date>
       <Case_Opened>09/18/2006</Case_Opened>
       <Responsible_Attorney>[R]TADC</Responsible_Attorney>
   </record>
   <record>
       <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
       <Case_No>0606-0000000055</Case_No>
       <Current_Status>-</Current_Status>
       <Current_Status_Expires>xxxxxxxxxx</Current_Status_Expires>
       <Birth_Date>05/27/1971</Birth_Date>
       <Case_Opened>09/18/2006</Case_Opened>
       <Responsible_Attorney>NR</Responsible_Attorney>
   </record>
</report>

At my work, we generate reports from a system that generates XML and we
then use the XSL to format the reports.  Users are able to choose the
columns they wish.
I'm trying to arrange it so that the data is generated in a table sorted
by the Beneficiary_Name, and without any duplicated data for the
beneficiary.  So, in the case of Peter Canada, the first record of his
that shows would have all the fields filled in, but each record after
that would only have Case_Opened and Responsible_Attorney, as those are
the only ones changing.

I've tried several different techniques, but I'm having no luck at all.
Any suggestions?



Garrett Murphy
gmurphy@xxxxxxxxxxxx

Current Thread