I want to show on an html report under a subhead
one agreement with multiple instances of supp_num in one report or page.
Assuming under agreement, we have 3 supp_num.
The report should display a subhead as followed:
agreement #: abcde
mgrname: manager name
supp_num #1: 1234
supp_num #2: 2345
supp_num #3: 3456
I am not sure if I need to create a hold file where I assigned the supp_num to supp_num1, then supp_num2, supp_num3 .
my master file looks like the following:
SEGNAME=SAVTMSTR, SEGTYPE=S2, $
FIELD=AGREEMENT, ALIAS=AGMTNO, FORMAT=A12, INDEX=I, $
FIELD=DATE_SUBM, ALIAS=DATE_SUBM, FORMAT=YMD, $
FIELD=MGRNAME, ALIAS=MGRN, FORMAT=A20, $
SEGNAME=SAVTSUPP, SEGTYPE=S1, PARENT=SAVTMSTR, $
FIELD=SUPP_NUM, ALIAS=SUPNUM, FORMAT=A10, INDEX=I, $
please provide suggestions how I should code this.This message has been edited. Last edited by: Kerry,
This example using the CAR file may give you some ideas:
TABLE FILE CAR SUM COMPUTE COUNTER/I5 = IF (COUNTRY NE LAST COUNTRY) THEN 1 ELSE (LAST COUNTER + 1); NOPRINT BY COUNTRY NOPRINT BY CAR NOPRINT ON CAR SUBFOOT "Country: <COUNTRY " WHEN COUNTER EQ 1 ; ON CAR SUBFOOT "Car #<COUNTER<+0>: <CAR " ON TABLE SET PAGE NOLEAD END
thanks, it worked
|Powered by Social Strata|