Change heading when value changed

Hi

I would like to produce below report:

The report will be divided by C-Service, specific code, organisation
number, candidate number, entry code, and component tile.
sub heading for c-service value change. (eg. c-service value "Y" =
c-service applications,   value "N" = Non C-Service Requests and
				  value "X" =  no heading.).

page throw on specific code changed.

PAGE:1
------------------------------------------------------------------------
------
NON C-SERVICE REQUESTS
Specific Code: 8000  XSLT Specification
------------------------------------------------------------------------
------
10101  FULLERTON READING SCHOOL
       0302 DAVIS               8000F
       0302 DAVIS               8000H
       0483 PAUL                8000F

10103  WILLIAMS COLLEGE
        1673  HARRY             8000F
        2508  GULLIS            8000F
        2508  GULLIS            8000H


PAGE:2
------------------------------------------------------------------------
------
NON C-SERVICE REQUESTS
Specific Code: 9876  Fop Specification
------------------------------------------------------------------------
------
10101  FULLERTON READING SCHOOL
       0302 BRAIN               9876F
       0302 BRAIN               9876H
       0483 PAUL                9876H

10103  ST.DUNSTONS
        1673  HARRY             9876F
        2508  GULLIS            9876F
        2508  GULLIS            9876H


------------------------------------------------------------------------
------
C-SERVICE REQUESTS
Specific Code: 8000  XSLT Specification
------------------------------------------------------------------------
------
10101  FULLERTON READING SCHOOL
       1220 SARTER               8000F
       1220 SARTER               8000H
       1223 SAMUAL               8000F

10103  WILLIAMS COLLEGE
        1673  HARRY             8000F
        0899  JAMES             8000F
        0899  JAMES             8000H


XML

<?xml version = '1.0'?>
<ROWSET>
     <ROW num="1">
          <ID>50758</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>XSLT SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATIONE>
          <CANDIDATE_NO>0302</CANDIDATE_NO>
          <CANDIDATE>DAVIS</CANDIDATE>
          <PRODUCT_CODE>8000F</PRODUCT_CODE>
          <COMPONENT_CODE>8000/1F</COMPONENT_CODE>
     </ROW>
     <ROW num="2">
          <ID>50640</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>XSLT SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATION>
          <CANDIDATE_NO>0302</CANDIDATE_NO>
          <CANDIDATE>DAVIS</CANDIDATE>
          <PRODUCT_CODE>8000H</PRODUCT_CODE>
          <COMPONENT_CODE>8000/2F</COMPONENT_CODE>
     </ROW>
     <ROW num="3">
          <ID>50356</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>XSLT SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATION>
          <CANDIDATE_NO>0483</CANDIDATE_NO>
          <CANDIDATE>PAUL</CANDIDATE>
          <PRODUCT_CODE>8000F</PRODUCT_CODE>
          <COMPONENT_CODE>8000/1F</COMPONENT_CODE>
     </ROW>
     <ROW num="4">
          <ID>50759</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>XSLT SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10103</ORGANISATION_NO>
          <ORGANISATION>WILLIAMS COLLEGE</ORGANISATION>
          <CANDIDATE_NO>1673</CANDIDATE_NO>
          <CANDIDATE>HARRY</CANDIDATE>
          <PRODUCT_CODE>8000F</PRODUCT_CODE>
          <COMPONENT_CODE>8000/1F</COMPONENT_CODE>
     </ROW>
     <ROW num="5">
          <ID>50770</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>XSLT SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10103</ORGANISATION_NO>
          <ORGANISATION>WILLIAMS COLLEGE</ORGANISATION>
          <CANDIDATE_NO>2508</CANDIDATE_NO>
          <CANDIDATE>GULLIS</CANDIDATE>
          <PRODUCT_CODE>8000F</PRODUCT_CODE>
          <COMPONENT_CODE>8000/1F</COMPONENT_CODE>
     </ROW>
     <ROW num="6">
          <ID>50779</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>XSLT SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10103</ORGANISATION_NO>
          <ORGANISATION>WILLIAMS COLLEGE</ORGANISATION>
          <CANDIDATE_NO>2508</CANDIDATE_NO>
          <CANDIDATE>GULLIS</CANDIDATE>
          <PRODUCT_CODE>8000H</PRODUCT_CODE>
          <COMPONENT_CODE>8000/1H</COMPONENT_CODE>
     </ROW>
     <ROW num="7">
          <ID>50359</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>9876</SPECIFIC_CODE>
          <SPECIFICNAME>Fop SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATION>
          <CANDIDATE_NO>0302</CANDIDATE_NO>
          <CANDIDATE>BRAIN</CANDIDATE>
          <PRODUCT_CODE>9876F</PRODUCT_CODE>
          <COMPONENT_CODE>9876/1F</COMPONENT_CODE>
     </ROW>

     <ROW num="8">
          <ID>60349</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>9876</SPECIFIC_CODE>
          <SPECIFICNAME>Fop SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATION>
          <CANDIDATE_NO>0302</CANDIDATE_NO>
          <CANDIDATE>BRAIN</CANDIDATE>
          <PRODUCT_CODE>9876H</PRODUCT_CODE>
          <COMPONENT_CODE>9876/1H</COMPONENT_CODE>
     </ROW>

     <ROW num="9">
          <ID>60349</ID>
          <C_SERVICE_IND>N</C_SERVICE_IND>
          <SPECIFIC_CODE>9876</SPECIFIC_CODE>
          <SPECIFICNAME>Fop SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATION>
          <CANDIDATE_NO>0483</CANDIDATE_NO>
          <CANDIDATE>PAUL</CANDIDATE>
          <PRODUCT_CODE>9876H</PRODUCT_CODE>
          <COMPONENT_CODE>9876/1H</COMPONENT_CODE>
     </ROW>


     <ROW num="10">
          <ID>60349</ID>
          <C_SERVICE_IND>Y</C_SERVICE_IND>
          <SPECIFIC_CODE>8000</SPECIFIC_CODE>
          <SPECIFICNAME>Fop SPECIFICATION</SYLLABUSNAME>
          <ORGANISATION_NO>10101</ORGANISATION_NO>
          <ORGANISATION>FULLERTON READING SCHOOL</ORGANISATION>
          <CANDIDATE_NO>1220</CANDIDATE_NO>
          <CANDIDATE>SARTER</CANDIDATE>
          <PRODUCT_CODE>8000H</PRODUCT_CODE>
          <COMPONENT_CODE>8000/1H</COMPONENT_CODE>
     </ROW>


</ROWSET>
Could you pelase help me how can I do it.

Much appreciate your help.

Regards
Srini


Visit our website at http://www.aqa.org.uk.

DISCLAIMER:
This e-mail is intended solely for the addressee, is strictly confidential,
and may also be legally privileged.  If you are not the addressee you may not
read, print, re-transmit, store or act in reliance on it or any attachments.
Please also destroy this message and notify us immediately by reply.

--+------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx>
--+--