Focal Point
Problem Generating PDF document

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

March 25, 2008, 05:19 AM
BHS6868
Problem Generating PDF document
Dear All,

Basically I have a code that generates about 200 lines of data into a PDF document. Here is the bottom part of the code:

ON TABLE SET PAGE-NUM OFF
ON TABLE SET TITLE OFF
ON TABLE SET STYLESHEET *
TYPE=REPORT, ORIENTATION=LANDSCAPE,$
TYPE=REPORT, SQUEEZE=ON, $
TYPE=REPORT, GRID=ON, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

The PDF Document is able to be generate without any problem.However the layout is way off as some columns overflow to a different page.

So I added some code just to make the fonts smaller.


ON TABLE SET PAGE-NUM OFF
ON TABLE SET TITLE OFF
ON TABLE SET STYLESHEET *
TYPE=REPORT, ORIENTATION=LANDSCAPE,$
TYPE=REPORT, SQUEEZE=ON, $
TYPE=REPORT, GRID=ON, $
-* Added this line
TYPE=DATA,COLOR=BLACK, FONT=ARIAL, SIZE=4,STYLE=NORMAL, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

The report then run for a long time and finally the browser says that It can't display the webpage because the connection timeout.

Any idea on how to solve this issue or monitor the WebFOCUS server?

Thanks in advance.


WebFOCUS 767 Server 64bit On Windows 2003 Server

WebFOCUS 767 Server for Developer Studio On windows XP

March 25, 2008, 07:08 AM
Tony A
Read Mickey Grackins excellent articles on the tips and techniques pages accessed from the "IB - Developer Center" link above.

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 
March 25, 2008, 09:26 AM
FrankDutch
The 200 lines of output might not be the problem, but the collection of that data.

If you post a bit more of your coding, tell us something about the database you are working on, try to report first in HTML, try to get some intermediate results, put some debugging code in the FEX and things like that, you may find an answer.




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