Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report content spans more than one page

Status
Not open for further replies.

Koen Piller

Programmer
Jun 30, 2005
841
NL
Hi,
I have to make a report which content spans more than one page. Not the data which cannot fit on one page, the content is spread over two pages. I believed that the reportwriter would break the content when reaching the bottom page and continue on the next. However VFP is obstructing / erroring: Detail band 2 is too large to fit on page. Which is not true since the detail band consists of 2 records only. Is there an instruction/command to start detail band 2 on a new page?
Regards,
Koen
 
Screenshot_-_1_31_2020_7_25_49_AM_fmn5uo.png


If you click on the second detail band, do you see this opttion?



If you want to get the best response to a question, please check out FAQ184-2483 first.
 
When there only was one detail, the simple rule was: Pagebreaks can occur after each detailband print, after each record. Only when even a single record/detail bands couldn't be printed on the current page, ie. it started too low or was higher than the design layout as some fields stretch with overflow, you would get a page break and that could also only cover cases, where this pagebreak gained enough place, ie the header was not repeated per page, there is no page header that puts any detail band so late, that it won'r match anyway. And only in thise circumstances you got an error.

I think there also was a bug only fixed in VFP SP2 about the influence of a summary or footer band, the space for it was reserved, even if it was not printed/only printed on the last page of the report, that was a bummer.

Multiple detail bands complicte the situation about what space is needed, I don't know the exact rules about splitting this into pages.

Anway, if starting bankds on a new page wouldn't help, managing narrower title/summary or header/footer could also have helped for future reference and for anyone in a similar, yet not exactly same situiation.

Bye, Olaf.

Olaf Doschke Software Engineering
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top