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 ------------------ WF v 7.1.1 OS - Win XP Output: PDF, EXL2K
December 01, 2005, 07:59 AM
Tony A
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
TThis message has been edited. Last edited by: Tony A,
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10