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] Heading Control on the OVERFLOW page
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Heading Control on the OVERFLOW page
 Login/Join
 
Platinum Member
posted
Hello,

Please run my code below to understand my requirement. I want to make some heading Lines disappear on the OVERFLOW pages. I tried in Composer and this is achieveable using Composer.

Is there any other way to get the same result not using components?

TABLE FILE CAR
PRINT
CAR
MODEL
BY SEATS PAGE-BREAK
HEADING
" "
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
" "
" "
" I WANT THIS LINE ONLY ON 1ST PAGE OF PAGE BREAK i.e 1,3,5"
" (NOT ON THE OVERFLOW PAGE. PAGES-2,4 & 6 ARE OVERFLOW PAGES)"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE='ENVELOPE-DL', LEFTMARGIN=0.5, RIGHTMARGIN=0.025, TOPMARGIN=0.1000,
BOTTOMMARGIN=0.4000, SQUEEZE=OFF, UNITS=IN, ORIENTATION=LANDSCAPE, TOPGAP=0.05, BOTTOMGAP=0.05,$
ENDSTYLE
END

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


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
If this is achievable using Composer, could you please post the code generated by Composer - the clue might be in there.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Does this help, use SUBHEAD:

TABLE FILE CAR
PRINT
CAR
MODEL
BY SEATS PAGE-BREAK
HEADING
" "
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
" "
" "

ON SEATS SUBHEAD
" I WANT THIS LINE ONLY ON 1ST PAGE OF PAGE BREAK i.e 1,3,5"
" (NOT ON THE OVERFLOW PAGE. PAGES-2,4 & 6 ARE OVERFLOW PAGES)"
" "

ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE='ENVELOPE-DL', LEFTMARGIN=0.5, RIGHTMARGIN=0.025, TOPMARGIN=0.1000,
BOTTOMMARGIN=0.4000, SQUEEZE=OFF, UNITS=IN, ORIENTATION=LANDSCAPE, TOPGAP=0.05, BOTTOMGAP=0.05,$
ENDSTYLE
END


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Francis,

The SUBHEAD appears only on the 1st page of the report. I want them to be on the pages 1,3 & 5.

-Hari
WF-769


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
The SUBHEAD indeed appears on pages 1, 3 and 5 because the SUBHEAD is for the SEATS column. I imagine, though, that you would like the SUBHEAD to appear above the column titles, not below - that is, if you require column titles.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Sorry for the confusion.
I typed in "ON TABLE SUBHEAD" and ran my report.

As per my requirements, i want the column titles and SUBHEADs above the titles.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
In Composer, the syntax "DisplayOn=OVERFLOW-ONLY" makes the component to appear only on the overflow page.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
Is this line ONLY an image, or is there also a text line? If it's only an image, we may be able to solve your problem.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
The line has an image and a text line as well.

-Hari


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This can be achieved only using Composer.
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
A rather crude method of doing this is -
TABLE FILE CAR
PRINT CAR
      MODEL
      COMPUTE OVERFLOW_PAGE/A1 = IF (TABPAGENO - (INT(TABPAGENO / 2) * 2)) EQ 1 THEN 'N' ELSE 'Y'; NOPRINT
   BY SEATS PAGE-BREAK
HEADING
" "
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
" "
" "
" I WANT THIS LINE ONLY ON 1ST PAGE OF PAGE BREAK i.e 1,3,5"
" (NOT ON THE OVERFLOW PAGE. PAGES-2,4 & 6 ARE OVERFLOW PAGES)"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE='ENVELOPE-DL', LEFTMARGIN=0.5, RIGHTMARGIN=0.025, TOPMARGIN=0.1000,
BOTTOMMARGIN=0.4000, SQUEEZE=OFF, UNITS=IN, ORIENTATION=LANDSCAPE, TOPGAP=0.05, BOTTOMGAP=0.05,$
TYPE=HEADING, LINE=5, COLOR=WHITE, WHEN=OVERFLOW_PAGE EQ 'Y', $
TYPE=HEADING, LINE=6, COLOR=WHITE, WHEN=OVERFLOW_PAGE EQ 'Y', $
ENDSTYLE
END

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5686 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Tony. Your technique was great, works perfectly. I appreciate ur efforts.
However, with my real data, not all sort value breaks equally to two pages.

I was wondering if there would be any technique to capture the Page number based on the Page-Break.

-Hari


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
The old disappearing text trick... Turn it white on white... Sometimes...
 
Posts: 3106 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hmmm, this could be coined as "the Copperfield technique" ... you know, as we already have McGyver for other useful purposes. Smiler



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
not all sort value breaks equally to two pages
In that case you'll need to revise the COMPUTEd value to signify when the header should be "shown".
PRINT MODEL
      COMPUTE OVERFLOW_PAGE/A1     = IF COUNTRY EQ LAST COUNTRY THEN 'Y' ELSE 'N'; NOPRINT
-*      COMPUTE OVERFLOW_PAGE/A1 = IF (TABPAGENO - (INT(TABPAGENO / 2) * 2)) EQ 1 THEN 'N' ELSE 'Y'; NOPRINT
   BY COUNTRY
   BY CAR PAGE-BREAK

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5686 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Tony. This was what i needed. Did not think it to be so simple and easy.Thanks again.

I changed the font size to 1, its perfect now.
TYPE=HEADING, LINE=5, COLOR=WHITE, SIZE=1, WHEN=OVERFLOW_PAGE EQ 'Y', $

-Hari


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
Originally posted by njsden:
"the Copperfield technique"


where can i find those Copperfield techniques?


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Heading Control on the OVERFLOW page

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