[SOLVED] Not enough space for subfoot, it starts a new page
I am trying to create a report which has about 30 lines in a subfoot. The problem is if there is no enough space on the first page to for all 30 lines, it starts a new page. But that leaves a big blank page. Does anyone know how to get some of the lines on the first page then continue on the second page?
Thanks.This message has been edited. Last edited by: Kerry,
October 14, 2009, 06:02 PM
What output format are you using ?
You could change the margins, or change the number of lines of the page, there are many options.
Also please update your signature. It helps in knowing what your environemt and version is.
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 14, 2009, 10:22 PM
It sounds like you want to split the SUBFOOT apart so it spans the page, right? If so, I don't think that a SUBFOOT can be split.
However, you can get creative and create several data items which can appear as a SUBFOOT. To get started with that: create (DEFINE) the SUBFOOT fields, create an associated sort field based on a specific number of lines displayed, and ON (that line counter field) SUBFOOT.
Creativity is the key for this. Then again, splitting the subfoot may not be what you're looking to accomplish here, is it?
October 15, 2009, 05:31 AM
I assume you are going to PDF, It's a limitation of SUBFOOT.
For PDF and Postscript reports, the heading or footing lines must fit within the maximum report width to be displayed properly. Also, in order for the report body to be displayed, the number of heading or footing lines must leave room on the page for at least one detail line (including column titles).
If it is PDF output then the easiest solution is to select a page size that is slightly larger than your standard.
You don't say where you are but if your in the US then you are probably using "Letter" (216 × 279 mm) or "A4" (210 × 297) if in most of Europe, try switching to "B4" (250 × 353) OR "C4" (229 × 324 ).
PDF couldn't care less and will scale it to the printer size for printing.
October 15, 2009, 03:36 PM
Thanks for all the replies. Yes it's for pdf format. I broke the subfoot into 4 pieces and it looks much better.