Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SUBHEAD(sometimes more than 1 subhead) at the top of all pages

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] SUBHEAD(sometimes more than 1 subhead) at the top of all pages
 Login/Join
 
Gold member
posted
Below is the sample code that shows first SUBHEAD(Region) alone at the top of all pages.
  
TABLE FILE GGSALES
PRINT
PRODUCT AS ''
CATEGORY AS ''
PCD AS ''
STCD AS ''
DATE AS ''
DOLLARS AS ''
AND COMPUTE ROWCNT/I9 = LAST ROWCNT + 1; NOPRINT
BY REGION NOPRINT
BY ST NOPRINT
BY CITY NOPRINT
BY TOTAL ROWCNT NOPRINT

ON REGION SUBHEAD
"Region:<8><REGION"

ON ST SUBHEAD
"State:<8><ST"

ON CITY SUBHEAD
" City:<8><CITY"
"<+0>Product<+7>Category<+3>Product code<+4>Store code<+4>Date of sales<+4>Total sales"

ON ROWCNT SUBHEAD
"Region:<8><REGION"
"<+0>Product<+7>Category<+3>Product code<+4>Store code<+4>Date of sales<+4>Total sales"
WHEN TABPAGENO NE LAST TABPAGENO;

ON TABLE SUBFOOT
""
"Total Fulfilled :<ROWCNT"
""
"End of Report."

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9,$
TYPE=HEADING, SIZE=10, STYLE=BOLD,$
TYPE=SUBHEAD, STYLE=NORMAL, SIZE=7,$
TYPE=SUBHEAD, COLUMN=N1, SIZE=7, JUSTIFY=CENTER, STYLE=BOLD,$
TYPE=TABHEADING,     SIZE=8,     STYLE=BOLD,$
TYPE=TABFOOTING,     SIZE=8,     STYLE=BOLD,$
TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=8,$
TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD,$

ENDSTYLE
END

Suppose if any of the page(other than 1st page) starts with new set of 'State' or 'City'(i.e.different from 1st page State or City names), then the page must be displayed with First header as Region, Second header as State or City respectively.

If old set of State or city records are followed in 2nd page, page shud display only the first header 'Region' only which is displaying now as per above code.

I tried giving various conditions under 'ON ROWCNT SUBHEAD', but could'nt resolve. Can someone provide a solution for this.

This message has been edited. Last edited by: Kerry,


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Virtuoso
posted Hide Post
Try adding PAGE-BREAK to each of your sort fields and see if that is what you are looking for.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Gold member
posted Hide Post
If i use PAGE-BREAK for each sort field, then i'm getting below output which i'm not looking for:
 
PAGE - 1
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Region: Midwest
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
.

----AFTER FEW PAGE WHERE 'State' IS CHANGED-----
State: MO
City: St. Louis
Product Category Product code Store code Date of sales Total sales
Region: Midwest
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1250 1997/03/01 24962
Espresso Coffee C141 R1250 1996/11/01 21333
.
.
.


Here first subhead is displayed twice in 1st page and also in other page when my 'State' is changed, 'Region' subhead display next to 'State' subhead.I'm looking for as shown below:
  
PAGE - 1
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
.
-----IF THERE IS NO CHANGE, THEN ONLY FIRST SUBHEAD ALONE DISPLAY (WHICH IS DISPLAYING ALREADY)-------
Region: Midwest
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1250 1997/03/01 24962
.
.
----IF 'State' IS CHANGED, diaplay State subhead next to 'Region' subhead-----
Region: Midwest
State: MO
City: St. Louis
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1250 1997/03/01 24962
Espresso Coffee C141 R1250 1996/11/01 21333
.
.
.


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Expert
posted Hide Post
  
APP APPENDPATH IBISAMP
-RUN
TABLE FILE GGSALES
HEADING
"Region:<8><REGION"
PRINT
PRODUCT AS ''
CATEGORY AS ''
PCD AS ''
STCD AS ''
DATE AS ''
DOLLARS AS ''
    COMPUTE ROWCNT1/I9 = IF REGION EQ LAST REGION THEN ROWCNT1 + 1 ELSE 1; NOPRINT
    COMPUTE ROWCNT2/I9 = IF ST     EQ LAST ST     THEN ROWCNT2 + 1 ELSE 1; NOPRINT
    COMPUTE ROWCNT3/I9 = IF CITY   EQ LAST CITY   THEN ROWCNT3 + 1 ELSE 1; NOPRINT
BY REGION NOPRINT
BY ST NOPRINT PAGE-BREAK
BY CITY NOPRINT
-*BY TOTAL ROWCNT NOPRINT

-*ON REGION SUBHEAD
-*"Region:<8><REGION"
-*WHEN ROWCNT1 EQ 1
ON ST SUBHEAD
"State:<8><ST"
WHEN ROWCNT2 EQ 1
ON CITY SUBHEAD
" City:<8><CITY"
"<+0>Product<+7>Category<+3>Product code<+4>Store code<+4>Date of sales<+4>Total sales"
" "
WHEN ROWCNT3 EQ 1
-*ON ROWCNT SUBHEAD
-*"Region:<8><REGION"
-*"<+0>Product<+7>Category<+3>Product code<+4>Store code<+4>Date of sales<+4>Total sales"
-*WHEN TABPAGENO NE LAST TABPAGENO;

ON TABLE SUBFOOT
""
-*"Total Fulfilled :<ROWCNT"
""
"End of Report."

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9,$
TYPE=HEADING, LINE=1, SIZE=7, STYLE=BOLD, JUSTIFY=LEFT,$
TYPE=SUBHEAD, STYLE=BOLD, SIZE=7,$
-*TYPE=SUBHEAD, COLUMN=N1, SIZE=7, JUSTIFY=CENTER, STYLE=BOLD,$
TYPE=TABHEADING,     SIZE=8,     STYLE=BOLD,$
TYPE=TABFOOTING,     SIZE=8,     STYLE=BOLD,$
TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=8,$
TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD,$

ENDSTYLE
END
-EXIT


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Virtuoso
posted Hide Post
Hey Tom...that looks good.

You going to Summit this year?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Hi Linda, Yep, waiting on IBI to open up the selections... Yourself?


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Virtuoso
posted Hide Post
I'm in!
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Cool Beans!!! C'ya in June...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Member
posted Hide Post
Hi,
Am looking as per below format.On my every page beofre any details i want subhead1(Region).There is no page break in btween.

PAGE - 1
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
.
-----IF THERE IS NO CHANGE FROM PREVIOUS PAGE TO NEXT PAGE, THEN ONLY FIRST SUBHEAD ALONE DETAILS(AS SHOWN BELOW)-------
Region: Midwest
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1250 1997/03/01 24962
.
.
----IF SAME PAGE 'State' IS CHANGED, diaplay State AND CITY subhead -----
State: MO
City: St. Louis
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1250 1997/03/01 24962
Espresso Coffee C141 R1250 1996/11/01 21333
.
.
.
--IF NEW OR NEXT PAGE REGION IS CHANGED THEN AGAIN DISPALY REGION,STATE ,CITY AND DETAILS------
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
.
--IF NEW OR NEXT PAGE STATE IS CHANGED THEN AGAIN DISPALY REGION,STATE ,CITY AND DETAILS------
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 3 | Registered: March 23, 2012Report This Post
Gold member
posted Hide Post
Tom, i want to display the columns names also in all pages.

i.e.above the records, i need to display columns names as shown below:
  
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
.
.


Right now these columns names are not displayed in all pages


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Member
posted Hide Post
Hi,
i want to move BY field in next page if it is the last line of current page.

PAGE - 1
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
Espresso Coffee C141 R1020 1997/04/01 20046
State: ML
---Page End
--page 2
City: Chica

Product Category Product code Store code Date
.
.
.
---------------------------------
what i expected

PAGE - 1
Region: Midwest
State: IL
City: Chicago
Product Category Product code Store code Date of sales Total sales
Espresso Coffee C141 R1020 1996/09/01 24510
Espresso Coffee C141 R1020 1997/04/01 20046
.
.
Espresso Coffee C141 R1020 1997/04/01 20046
. blank space
---Page End
page-2
State: ML
City: Chica
Product Category Product code Store code Date
.
.
.
--------------------------------------


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 3 | Registered: March 23, 2012Report This Post
Virtuoso
posted Hide Post
HEADING is for headings that appear on the top of every page. (These can still contain embedded fields so you may find that useful in finding your solution.) SUBHEAD is controlled by the BY fields used. They appear only when sort values change which may or may not be at the top of a page. The only way to force them to be at the top is to page-break on the BY field as well. Subheadings always appear beneath the column headings. (All of this behavior is described in the documentation so that would be a good place to start.) If you want subheadings to appear above the column headings, you have to put AS '' on each of the SUM/PRINT/BY fields and then insert your column headings as part of the SUBHEAD. I would suggest creating DEFINE/COMPUTE fields and inserting them in your HEADING/SUBHEAD as needed.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SUBHEAD(sometimes more than 1 subhead) at the top of all pages

Copyright © 1996-2020 Information Builders