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
July 20, 2010, 05:04 PM
FrankDutch
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
July 20, 2010, 05:09 PM
Prarie
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
July 20, 2010, 06:26 PM
Waz
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
July 21, 2010, 09:27 AM
slfmr
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
July 21, 2010, 11:15 AM
Darin Lee
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
July 21, 2010, 11:58 AM
slfmr
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
July 23, 2010, 12:09 PM
slfmr
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