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.