Hi,



I have my report output something like this –



Class Xth

Name Marks Rank

Alpana 100 1

Smita 80 2

Dharma 75 3

Class Xth Total Marks Scored --- 255

Computers 85

Electronics 90

Mechanical 75





Here Class xth is the subhead and this way I have various subheads. Under this subhead I am printing 3 columns which has 3 rows. And then I have a subfoot block which contains the total marks obtained and 3 more rows for each Name.



My SP is like this



Name Marks Rank Subject for which score is highest Subject Marks

Alpana 100 1 Computers 85

Smita 80 2 Electronics 90

Dharma 75 3 Mechanical 75





How can I get all the rows of last 2 columns in the subfoot block for Name?



When I print the last 2 column under subfoot it prints only the last row.



Thanks in Advance,

Alpana.

Dharma,

Just filedef a file with the filetype of "fex" and then perform an initial extract of the subject and highest marks into this file. If you bound the fields with a double quote mark and then INCLUDE the file in your SUBFOOT you will get what you are after. Copy and paste this code into a single fex and run it to see what I mean -

-* This part is just to get a file like the one you quote
APP FI DHARMA DISK DHARMA.MAS (LRECL 80
-RUN
-WRITE DHARMA
-WRITE DHARMA FILE=DHARMA,SUFFIX=FOC
-WRITE DHARMA SEGNAME=SEG1
-WRITE DHARMA FIELD=NAME,,A15,A15,$
-WRITE DHARMA FIELD=MARKS,,I9,I9,$
-WRITE DHARMA FIELD=RANK,,I9,I9,$
-WRITE DHARMA FIELD=SUBJECT,,A15,A15,$
-WRITE DHARMA FIELD=SUB_MARKS,,I9,I9,$
-RUN

CREATE FILE DHARMA
MODIFY FILE DHARMA
FIXFORM NAME/A15 MARKS/A9 RANK/A9 SUBJECT/A15 SUB_MARKS/A9
DATA
Alpana               100        1Computers             85
Smita                 80        2Electronics           90
Dharma                75        3Mechanical            75
END
-RUN

-* This is the important bit where your subfoot is created
DEFINE FILE DHARMA
QUOTES/A1 = '"';
END
TABLE FILE DHARMA
PRINT QUOTES SUBJECT MARKS QUOTES
ON TABLE SAVE
END
-RUN
TABLE FILE DHARMA
SUM MARKS
    RANK
 BY NAME
ON TABLE SUBFOOT
"Class Xth Total Marks Scored --- <ST.MARKS"
-INCLUDE SAVE
END

T

This message has been edited. Last edited by: Tony A,