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 have a wide WebFOCUS report that can be displayed in both HTML and PDF formats. On the HTML display format, it looks fine. However, on the PDF display format, it displays in three pages.
How can I make the PDF format to display in one page?
Thanks, StevenThis message has been edited. Last edited by: Kerry,
Change the page size... Change the page orientation... Reduce the font size... Reduce the gap between columns... Turn SQUEEZE on... Use SQUEEZE or WRAP to wrap a wide column... Read the manual... Search on FocalPoint...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
If it takes three pages to print out the report in PDF format, you're just trying to fit too much stuff on one page. That being said, my finance people always want reports like this - 30 columns and it all has to fit on one page. Screens scroll, paper doesn't - so you've got to physically resize and arrange things, as Tony mentions, to fit onto the paper. Sometimes this may require font size 5 and an attached magnifying glass! Anyway, it may require you to use separate stylesheets or completely separate blocks of code. You can check the desired output format and branch using Dialogue Manager code to the appropriate code.
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, 2007
Change the page size of the PDF report in the stylesheet.
PAGESIZE=E
E is 34x44 inches
TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE=E, ORIENTATION=PORTRAIT, $
-* PAGESIZE=A0, ORIENTATION=PORTRAIT, $
ENDSTYLE
END
There are many page sizes available, have a look at the documentation.
Acrobat will resize to print, all depends on what printer you have and what size paper it prints on.This message has been edited. Last edited by: Waz,
Renee Teatro did a presentation at Summit that included techniques on how to force linebreaks into data for PDFs. See the PPT file at the link below starting on silde 29.
You may also want to look at FOLD-LINE or the usage of OVER. There are a number of ways to "wrap" information on a page in WebFOCUS. I'm not sure exactly what you are looking for so take a look at these to see if one of them gets you what you need.
Thanks!
Mickey
FOCUS/WebFOCUS 1990 - 2011
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003