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     Compound Report Questions - Added Examples For Clarity

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Compound Report Questions - Added Examples For Clarity
 Login/Join
 
slfmr
Platinum Member
posted
I've searched the forum but may have missed something, but for some reason I can't use the FOOTING BOTTOM with compound NOBREAK reports.

See example:

5 files
test.fex, test1.fex, test2,fex, test3.fex, test4.fex


test.fex:

EX TEST1 PDF='OPEN',OUTPUT='PDF',NOBREAK=''
EX TEST2 PDF=' ',OUTPUT='PDF',NOBREAK='NOBREAK'
EX TEST3 PDF=' ',OUTPUT='PDF',NOBREAK='NOBREAK'
EX TEST4 PDF='CLOSE',OUTPUT='PDF',NOBREAK=''

test1.fex, test2.fex, test3.fex and test4.fex all look like the following:

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
FOOTING
"ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &OUTPUT &PDF &NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT,$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9,$
ENDSTYLE
END


When you run the above, the page numbers are below the report. What I want is there to be only 1 page number at the very bottom, but when I use FOOTING BOTTOM, it ends up giving me 4 pages as if the NOBREAK was not set.

Any thoughts on how to fix this? I have an extremely complex report that uses loops and appends different fex files for different report types (tables and text) and can't see to get this working.


Also I have a header that I want on every page... not every report, but if I do a heading, and I have a table that spans multiple pages, the second page is missing the heading.

Any thoughts or good documentation on that? I've looked (or so I thought) and nothing has really helped.

In addition, when I have a table that spans a couple pages, the bottom line of the table is missing.... I've tried printplus on and no split...

Here is an example:

test.fex is as follows:

SET PRINTPLUS = ON
EX TEST1 PDF='OPEN',OUTPUT='PDF',NOBREAK='NOBREAK'
EX TEST2 PDF=' ',OUTPUT='PDF',NOBREAK='NOBREAK'
EX TEST21 PDF='CLOSE',OUTPUT='PDF',NOBREAK=''

test1.fex:

TABLE FILE CAR
HEADING
"CHAPTER 1.1"
PRINT COUNTRY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT &OUTPUT &PDF &NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT,$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9,$
ENDSTYLE
END

test2.fex:

TABLE FILE CAR
"SECTION 1.1"
PRINT COUNTRY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT &OUTPUT &PDF &NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9,$
ENDSTYLE
END


test21.fex:


DEFINE FILE CAR
LONGVAL/A2000 WITH CAR = 'This is a long value so I can test the issue of the table missing a bottom line when running a compound report. This is a test value.';
END

TABLE FILE CAR
PRINT
COUNTRY
CAR
LONGVAL
ON TABLE HOLD AS HC
MORE
FILE CAR
MORE
FILE CAR
MORE
FILE CAR
MORE
FILE CAR
MORE
FILE CAR
END

TABLE FILE HC
PRINT
COUNTRY
CAR
LONGVAL
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT &OUTPUT &PDF &NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT, SIZE=9, GRID=OFF, FONT='ARIAL', $
TYPE=REPORT, COLUMN=N1,WRAP=2,$
TYPE=REPORT, COLUMN=N2,WRAP=2,$
TYPE=REPORT, COLUMN=N3,WRAP=3,$
TYPE=TITLE,GRID=ON,$
TYPE=DATA,GRID=ON,$
TYPE=DATA,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,$
TYPE=TITLE,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,$
ENDSTYLE
END


Thank you for any help!

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


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report This Post
FrankDutch
Virtuoso
posted Hide Post
this should work in version 7.6.9 but in the former I always had problems with the page numbering




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Prarie
Virtuoso
posted Hide Post
This is from the IBI site

This is expected behavior if FOOTING BOTTOM is used. The idea of FOOTING
BOTTOM is to place it at the very BOTTOM of the physical page. Therefore,
a NEW PAGE will display the next REPORT regardless of the NOBREAK option.
However, if you use FOOTING instead of FOOTING BOTTOM, the result is
that the FOOTING is placed at the end of the report page directly after it.
Then, the next PDF report can and will display below it if there is enough
room.

For example:

TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END
TABLE FILE CAR
PRINT MODEL BODYTYPE
BY COUNTRY
BY CAR
FOOTING
"This is the footing of the second report"
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF CLOSE NOBREAK
END


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Waz
Expert
posted Hide Post
As Prarie has quoted from IBI, its illogical captain.

Putting a footing at the bottom of the page, then adding a new report after it, just will not work.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
slfmr
Platinum Member
posted Hide Post
Okay the footing for the page number is out of the question... I don't know what report will be at the end of the page. If the data is there a table is created if not, it moves to the next set of data.

Is there a way to tell when I get to the end of a page?

I might look into getting 7.6.9

Any thoughts on the other two issues? The header or missing line?

Thank you


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report This Post
Darin Lee
Virtuoso
posted Hide Post
Have you tried using a Page Master in the compound layout tool? This isupposed to make it easier for page-numbering, footings, etc.


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
slfmr
Platinum Member
posted Hide Post
I'm not familiar with Page Master layout but I tried playing around with it in Dev Studio and it's not very intuitive... or I'm just not used to not writing the code.

What I have is a "driver" file that pulls data (config) and based on that creates "chapters" and sections. So if my data tables has:

Columns
Report
Chapter
Chapter Data
Section
Section Data

Then for each row it will create a report. So Chapter 1 and its data, then Section 1.1 (under Chapter 1) etc...

Would this work with page master layout? Is there an CAR file example anywhere or documentation on this?


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report This Post
slfmr
Platinum Member
posted Hide Post
Using my example below, why on the second page does &FOCNEXTPAGE say 2 when it should be 3?

My driver test file is:

SET PRINTPLUS = ON
SET FOCFIRSTPAGE = 1
SET COMPOUND = 'OPEN NOBREAK'
EX TEST3
-RUN
SET COMPOUND = 'NOBREAK'
-REPEAT LP 20 TIMES
SET COMPOUND = 'NOBREAK'
EX TEST3
-RUN
-LP
SET COMPOUND = 'CLOSE'
EX TEST3
-RUN

My TEST 3 file is:

TABLE FILE CAR
PRINT
COUNTRY AS ''
CAR AS ''
WHERE RECORDLIMIT EQ 1
FOOTING
"NEXT PAGE IS &FOCNEXTPAGE"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET PAGE NOLEAD
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,$
ENDSTYLE
END


Any thoughts? I figure if I can figure out this page numbering thing than I can manipulate everything else... when to put headers and footers etc...

Thank you!


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report 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     Compound Report Questions - Added Examples For Clarity

Copyright © 1996-2020 Information Builders