Focal Point
[SOLVED] multiple instances of one field on subhead report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/618104935

October 03, 2010, 12:43 PM
ibiweb
[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:

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, $
etc...
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,


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



WebFOCUS 7.7.05
October 05, 2010, 06:33 PM
ibiweb
thanks, it worked


Webfocus Focus
Unix
Windows