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.
I've been trying to get a compound PDF to print reports in a flexible way, but am not very successful. Issue is: I have two reports on the compound PDF page. Both occupy half the page (when designing) so nr 2 has been placed immediately below nr 1. Problem is that I do not know up front how many records there will be in report1. What I'd like to see as a result is that report1 starts and fills the page, overflows and goes to the next page etc etc, until there are no more records, and that only then report2 starts. What I see happening is that report1 starts, overflows to next pages and such, but report2 is also started on the first page and overwrites report1. And I can't seem to get it right ...This message has been edited. Last edited by: GamP,
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
SET COMPOUND = OPEN NOBREAK
-INCLUDE PART1.PDF
SET COMPOUND = NOBREAK
-INCLUDE PART2.PDF
SET COMPOUND =
-INCLUDE PART3.PDF
SET COMPOUND = CLOSE
-INCLUDE PART4.PDF
etc.
_____________________ WF: 8.0.0.9 > going 8.2.0.5
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010
-* File try_it1.fex
-DEFAULT &STRNG = 'a'
TABLE FILE HR
PRINT *
WHERE LASTNAME CONTAINS &STRNG.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
-*ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
INCLUDE = ENblue-medium,
$
ENDSTYLE
END
and:
-* File: try_it2.fex
-DEFAULT &STRNG = 'a'
TABLE FILE INVENTO
SUM PRICE
COST
QUANTITYINSTOCK
BY PRODUCTNAME
BY PRODUCTCATEGORY
WHERE PRODUCTCATEGORY CONTAINS &STRNG.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
-*ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
INCLUDE = ENblue-medium,
$
ENDSTYLE
END
Dave: I tried the compound open nobreak, no luck. Doug: Both reports are set to flowing. I have no idea how to link report2 to report1. There is nothing in the graphical interface that even hints to this possibility.
Any ideas anyone?
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
You need to change the POSITION ttributes to relative instead of arbitary by using + or - and also make use of the RELATIVE-TO, RELATIVE-POINT and POSITION-POINT syntax.
You should be able to locate them in the online help files - there's too much to include it here
Good luck.
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: 5694 | Location: United Kingdom | Registered: April 08, 2004
GamP, IMHO you should tag your post as [SOLVED] not [CLOSED] since you found a solution; just to follow forum's guidelines.
[SOLVED] – This should be placed in the subject title when a solution to the question has been posted in the thread. There are many great discussions and solutions on Focal Point. Using this keyword will help communicate to everyone when a solution has been received. This will also be helpful in the future for new Focal Point members when they are searching for answers to questions they have. If this keyword appears in the subject title they will know there is a solution in the thread.
[CLOSED] – This should be placed in the subject title when if a solution/suggestion is given, or if a request for more info is made, e.g. code, master files, and we follow-up with the topic starter via one private message, but there is no response or update from the topic starter in 2 business days. This is similar to [SOLVED] except that there is no final confirmation from the topic starter.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013