[SOLVED] multiple instances of one field on subhead report
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:
please provide suggestions how I should code this.This message has been edited. Last edited by: Kerry,
Webfocus Focus Unix Windows
October 03, 2010, 04:07 PM
Dan Satchell
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