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     That madness called Compound PDF's again...

Read-Only Read-Only Topic
Go
Search
Notify
Tools
That madness called Compound PDF's again...
 Login/Join
 
Virtuoso
posted
Okay, so I am knee-deep in creating a compound (PDF) report from scratch and I ran into a problem...

Fact is, I have a page-layout where at the top of the first page I put a smallish report containing a legend for the report following it. I'd like that report to follow the legend starting on the same page. With some searching, I found that you can define page-layout components to be "flowing" by using '*' for width and height, like this:
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(1.323 2.143), DIMENSION=(* *),
 METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 23.283cm; HEIGHT: 7.938cm; OVERFLOW: auto; TOP: 2.143cm; LEFT: 1.323cm', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(1.323 10.610), DIMENSION=(* *),
 METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 23.548cm; HEIGHT: 6.615cm; OVERFLOW: auto; TOP: 10.61cm; LEFT: 1.323cm', $


The bottom component however, tends to flow over to the next page(s). For some reason on those overflow pages, the report top isn't at the top of the page but instead is around where the legend report ended! Not what I had in mind. Any way to fix this?

I attempted to create a simple example, but the result got rather hilarious - WebFOCUS is really bad at overflowing content! Look at the result of this...
-* File compound_generated.fex
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=CM, $
OBJECT=TOC, NAME='TOC', TEXT='<font face="ARIAL" size=10 color=#000000>Table of Contents</font>', MARKUP=ON, TOC-NUMBERING=ON, POSITION=(0.476 2.117), DIMENSION=(18.759 17.145), font='ARIAL', color=RGB(0 0 0),  size=10, METADATA=' TOCTITLE: Table of Contents', $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=A4,  $

PAGELAYOUT=ALL, NAME='Page Master', $
OBJECT=STRING, NAME='HeadingText', TEXT='<font face="ARIAL" size=14><center>Heading text</center></font>', POSITION=(0.476 0.635), MARKUP=ON, WRAP=ON, DIMENSION=(15.796 0.953), style=bold, METADATA='', $
OBJECT=STRING, NAME='page-number', TEXT='<font face="ARIAL" size=10><ibi-page-number/></font>', POSITION=(18.494 20.003), MARKUP=ON, WRAP=ON, DIMENSION=(1.799 0.318),  METADATA='', $
COMPONENT='DfltCmpt2', POSITION=(0 0), DIMENSION=(0 0), $

PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=PORTRAIT, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(1.323 2.143), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 23.283cm; HEIGHT: 7.938cm; OVERFLOW: auto; TOP: 2.143cm; LEFT: 1.323cm', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(1.323 10.610), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 23.548cm; HEIGHT: 6.615cm; OVERFLOW: auto; TOP: 10.61cm; LEFT: 1.323cm', $
END
SET COMPONENT='DfltCmpt2'
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
IF READLIMIT EQ 1
ON TABLE SET PREVIEW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT CAR
BY COUNTRY
END
SET COMPONENT='report2'
-*component_type report
TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS CAR0 FORMAT FOCUS INDEX COUNTRY CAR
END
-RUN

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS CAR00 FORMAT FOCUS INDEX COUNTRY CAR
END
-RUN

JOIN COUNTRY IN CAR0 TAG X1 TO MULTIPLE COUNTRY IN CAR0 TAG X2 AS J0
JOIN COUNTRY IN CAR0 TO MULTIPLE COUNTRY IN CAR00 TAG X3 AS J1
TABLE FILE CAR0
PRINT
 X2.COUNTRY
 X2.CAR
 X3.COUNTRY
 X3.CAR
BY X1.COUNTRY
BY X1.CAR
END
COMPOUND END


On WebFOCUS 7.6.11 that generates 3 blank pages and on the 4th page the content overflowing at the right side of the page is drawn straight over what was on the left side of the same page!
On 7.7 it's a little less bad, the TOC actually works and you don't get the blank pages, but it's still not drawn right!

Am I doing something wrong here?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Expert
posted Hide Post
Thats one of the reasons I stay away from it, or have each report formatted to exact sizes.

One interesting diversion...

Try changing the orientation and page size in section 1 definition to LANDSCAPE and A3, and see what happens. Smiler


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
Virtuoso
posted Hide Post
Oh, I can predict what happens with A3. That way the contents would fit the page and not overwrite themselves.

That's actually what I did in one such case already, but it doesn't really help when the number and width of your across-columns isn't known beforehand. Sure, I can verify in the DB what the max count and widths would be at the moment, but people enter new data all the time and it will one day (probably sooner than later, Murphy is like that) start wrapping again...

Anyway, the real issue I was trying to solve is that my overflow pages don't start at the the top of the page. If I can solve that, I can at least produce a usable PDF report. If not, I'll just stick with HTML, but I think the users will see that as a regression over their old BO report.

From the looks of things the PDF report generation tools are a bit immature. Without applying diapers you end up with a mess, but the diapers are a bit unwieldy too.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Virtuoso
posted Hide Post
Sounds familiar, but what about calculating in a first small report how many columns you need?
Once you know that, you might be able to split the report into 2, 3 or more sections and build those sections as separate reports?
This is something we did in a financial reporting that holds max 8 columns.




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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     That madness called Compound PDF's again...

Copyright © 1996-2020 Information Builders