Widow and Orphan Control in FoxPro Report Writer

Last reviewed: April 17, 1995
Article ID: Q101297
The information in this article applies to:
  • Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SUMMARY

The FoxPro Report Writer may break multiple detail lines for a single record onto multiple pages, creating orphan and widow lines.

An orphan is a single (or partial) line printed at the bottom of the first page from that record, and a widow is a single (or partial) line printed on the second page from that same record.

Using one of the methods below, you can force all the detail lines for a record to print on the same page in the FoxPro Report Writer.

MORE INFORMATION

NOTE: This method assumes that every detail band will have the same number of lines.

The following steps will allow forced widow and orphan control:

  1. Create a new report with a number of lines in the detail band.

  2. From the Report menu, choose Data Grouping.

  3. Add a new data group. For the group field, specify RECNO(), the FoxPro function that returns the current record number.

  4. Indicate the number of lines in the detail band in the "# of rows following header" portion of the group dialog box.

NOTE: The above method can be used even if there are other data groupings in the report. The RECNO() grouping should be the last grouping in the list. Usually, there will be no information in the data group heading for RECNO().


Additional reference words: FoxDos 2.00 2.50 2.50a undesirable bad page
break
KBCategory: kbprint kbprb
KBSubcategory:


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.