Focal Point
PDF Report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6061046472

March 05, 2008, 10:33 AM
Majid Jeddi
PDF Report
Hi,

I am creating a report in MRE that contains 6 columns.
When the report output is html everything is ok.
But if I use PDF as out put I am not able to see the result in one page: the first column is in the first page the second and the third in the next page and so on.

Did somebody encounter this issue?

Thanks for your help.

Majid.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
March 05, 2008, 10:38 AM
Prarie
Try adding this to your stylesheet

TYPE=REPORT, SIZE=8, SQUEEZE=ON,ORIENTATION=LANDSCAPE,$


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Thanks Prarie. It works


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
What you are experiencing is standard functionality for creating PDf reports. If the width of all columns exceed the available page width, the report is "paneled." You may have noticed a

(FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: xx.xx INCHES

The problem with using SQUEEZE in PDF report is that this may fix the problem some or most of the time, but invariably there will be a record that fills the entire length of a field and cannot be squeezed, so the report is paneled. As a rule, I ALWAYS turn SQUEEZE=OFF in my PDF reports, and play with other attributes like margin and font size to make sure that the report will always display correctly regardless of the record contents. Occasionally, I will set SQUEEZE=n on a particular column (n is the width in inches or whatever your units are) which accomplishes the same thing - column width is always the same.


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
Darin,

In your case you probably would want to use WRAP=n instead of SQUEEZE=n. Using SQUEEZE will truncate the column if it is too long and the output is PDF.

Majid,

Read the following two articles for information about formatting for PDF and HTML.

http://www.informationbuilders.com/support/developers/htmlpdf.html

http://www.informationbuilders.com/support/developers/htmlpdf_part2.html


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011