Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] multiple instances of one field on subhead report
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] multiple instances of one field on subhead report
 Login/Join
 
Member
posted
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
 
Posts: 13 | Location: NJ, PA, DE | Registered: March 05, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Member
posted Hide Post
thanks, it worked


Webfocus Focus
Unix
Windows
 
Posts: 13 | Location: NJ, PA, DE | Registered: March 05, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] multiple instances of one field on subhead report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.