Focal Point
Data overlaps on compound pdf reports?

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

June 01, 2005, 02:38 PM
<new2focus>
Data overlaps on compound pdf reports?
Are there any general rules for creating compound pdf reports? I am trying to create a compound report in the following manner

Report 1 (vendor information)
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET COMPOUND OPEN

LOOP (Read all the item information for the vendor order by department id)

Report 2 (Checks for every new department and displays only if any department level discount information exists)
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET COMPOUND NOBREAK

Report 3 (item information)
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET COMPOUND NOBREAK

Report 4 (pricing information)
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET COMPOUND NOBREAK

END LOOP

Report 5 (Dummy report for closing the compound report)
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET COMPOUND CLOSE

Webfocus is generating the report correctly for some vendors, but for others some pages are getting overlapped. (Based on the number of times the report 2 appears I guess - data from report2 and one or more report 3 & 4 are displaying over one another). I am setting the margin and other layout parameters as the same for all the reports as follows.

ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='A4', SQUEEZE=ON, ORIENTATION=LANDSCAPE,
LEFTMARGIN=0.6, RIGHTMARGIN=0.3, TOPMARGIN=0.1, BOTTOMMARGIN=0.1, $

TYPE=REPORT, GRID=OFF, TOPGAP=0.03, BOTTOMGAP=0.06,
FONT='HELVETICA', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $

If any one is interested I can email you the procedures and the output pdf.

Any suggestions would be truly appreciated.
June 22, 2005, 05:43 AM
Piipster
What release is this?
June 22, 2005, 05:52 AM
Piipster
... and have you opened a case with the Support Desk on this?

It sounds like you should, if you still haven't gotten it working.
July 07, 2005, 03:56 PM
Kerry
Hi new,

Is this still an outstanding issue for you? Did you try the search function in Focal Point?

Please check the following links and see if any of these can be helpful to you.

Compound PDF report
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/
3931038331/r/3931038331


Page-Break in compound HTML report
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/
8431038331/r/8431038331


If these posts don't answer your questions, then this may be related to detailed info such as the version of Adobe, WF, etc. At that point, I would strong suggest that you should open up a case with IBI Tech Support Help Desk and have a tech support representative to work with you. Big Grin

Hope this info helps you.

Cheers,

Kerry

This message has been edited. Last edited by: Kerry,
July 08, 2005, 02:04 PM
Kamesh
Can you send me your focexec and output PDF? I have one report exactly the same way you mentioned here.

My emailid is, g_kamesh@yahoo.com