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.
We have a challence to control the information printed on the front side and back side of an Invoice (Duplex).
We have a Compound Document containing 2 different Documents (1 fexfile). The length of the 1st Document (Invoice) is always variable - i.e. let's say 3 pages. The 2nd Document (Terms & Conditions) has always 1 page.
The request is to print Terms & Conditions on the back side of every Invoice page.
Ex. Front Side 1st page Docu 1 (1st page) Back Side 1st page Docu 2 (single page)
Front Side 2nd page Docu 1 (2nd page) Back Side 2nd page Docu 2 (single page)
Front Side 3st page Docu 1 (3rd page) Back Side 3st page Docu 2 (single page)
Does anybody have an idea how to solve this request ? All I know it needs to be a kind of loop...but the problem is that WebFocus doesn't know at run time the number of pages ...
Well, you could do it in two stages with a HOLD as the first stage. That way you will be able to store a count of the pages for each document you want printed.
I'd be surprised if there aren't other ways to do it in a single pass as well.
Is there soms kind of relation between the two reports? If you know where to put the page breaks for the first report by the number of lines it should be possible to combine the two reports.
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, 2006
Tried it but got a problem due to the Styling. Thanks George
quote:
Originally posted by George Patton: Well, you could do it in two stages with a HOLD as the first stage. That way you will be able to store a count of the pages for each document you want printed.
I'd be surprised if there aren't other ways to do it in a single pass as well.
WF7703M, Windows 2008 server, Oracle WebLogic 11g, MSSQL 2008 R2
Unfortunately the received proposals didn't work out due to the complex Styling approach we are using. We do have 3 different Type of pages in the Invoice Document with different nbr of lines per page. The length of any line is variable thus we can't predefine anything.
We are now testing a possibility to use A3 format - showing left side the Invoice Document and right side the T&C.
The only thing to solve now is to force a Printer printing an A3 document as A4 format. If anybody has any idea would be great
WF7703M, Windows 2008 server, Oracle WebLogic 11g, MSSQL 2008 R2
The length of the 1st Document (Invoice) is always variable - i.e. let's say 3 pages.
You could make the Invoice reports "Always Fixed (length)" by programatically tracking lines per page and "breaking" the report into pieces based on your line count. Then the compound report would be something like
SET COMPONENT='report1'
-INCLUDE invoice_part1.fex
SET COMPONENT='report2'
-INCLUDE invoice_TandC.fex
SET COMPONENT='report3'
-INCLUDE invoice_part2.fex
SET COMPONENT='report4'
-INCLUDE invoice_TandC.fex
SET COMPONENT='report5'
-INCLUDE invoice_part3.fex
SET COMPONENT='report2'
-INCLUDE invoice_TandC.fex
-* and so on...
Of course you'll need to check for LPP in each "invoice_part#.fex". But, Yes, we can do that in WebFOCUS"...
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005