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     Compound Report :Overflowing Page
Go
New
Search
Notify
Tools
Reply
  
Compound Report :Overflowing Page
 Login/Join
 
Platinum Member
posted
Hi,

I am building a compound report with a single report in it.
The single report actually generates multiple tables based on different BY FIELD category.
I achieve that using the SUBHEAD on the BY FIELD as shown below.

Here is how the compound report looks like :
SET HTMLARCHIVE=ON
*-HOLD_SOURCE
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.0^Margins_Top=0.0^Margins_Right=0.0^Margins_Bottom=0.0^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=LETTER, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.0, TOPMARGIN=0.0, ORIENTATION=PORTRAIT, METADATA='BOTTOMMARGIN=0.0,TOPMARGIN=0.0,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
OBJECT=STRING, NAME='txt1', TEXT='<font color="#ffffff" face="CALIBRI " size=26>SALES REPORT</font>', POSITION=(0.5 0.56), MARKUP=ON, WRAP=ON, DIMENSION=(5.522 0.521),  METADATA='left: 0.850in; top: 5.808in; width: 3.522in; height: 0.521in; color: rgb(255, 0, 102); font-family: CALIBRI; font-size: 33pt; position: absolute; z-index: 2; -ms-word-wrap: break-word;', $
OBJECT=STRING, NAME='txt2', TEXT='<font color="#ffffff" face="CALIBRI " size=10>SOME TEXT</font>', POSITION=(5.75 1.38), MARKUP=ON, WRAP=ON, DIMENSION=(5.522 0.521),  METADATA='left: 0.850in; top: 5.808in; width: 3.522in; height: 0.521in; color: rgb(255, 0, 102); font-family: CALIBRI ; font-size: 33pt; position: absolute; z-index: 2; -ms-word-wrap: break-word;', $
-------


Then i reference the below report as the report component.
  
TABLE FILE CAR
SUM
SALES
BY COUNTRY NOPRINT
BY CAR 
ON COUNTRY SUBHEAD
"COUNTRY: <COUNTRY"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
ENDSTYLE
END


I am also applying NO-SPLIT to avoid breaking to the next page in between.

I have set the PAGE LAYOUT to overflow instead of fixed as the report can go multiple pages.
Problem:
When it overflows to the second page i want to display something else not the two TEXT OBJECT as shown above.
I can do that using Branching to a label,but i am finding it hard to do the check to see if the report overflowed to second page.
I can use to display page number in a text object ,but can't use that as a variable to do the page number check.

Any one encountered such an issue?


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 217 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Srajeevan

Since no one was able to provide any guidance I hope you opened a case with techsupport...


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1896 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Compound Report :Overflowing Page

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