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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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,
Posts: 18 | Location: Canada | Registered: October 24, 2006
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?
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
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.