Vfp how to make overflow report print on new page

VFP8. Report with single grouping on recno('tablename'). Nothing in group
header. 9 fields in detail band. Last two are memo with stretch and float
applied. Several text fields in group footer.

At the top of the detail band I have a field of text "Continued from
previous page. ". I have it set to print when detail overflows to new page.
Print Repeated Values is set to No. Remove line when blank is checked and
the Print When expression field is blank.

The field does print at the top of the page when the detail overflows to the
next page for a record. But, the field also prints at the beginning of the
detail for the first record on the report. Cannot figure out why. Seems
like it should not print on the first record since this is not overflow from
previous page.

Does anyone have any ideas why this would do this?
Best Regards,
Brian Hiatt

Dennis Longfellow 2005-09-21 14:21:59 UTC

Post by Brian Hiatt
At the top of the detail band I have a field of text "Continued from
previous page. ". I have it set to print when detail overflows to new page.
Print Repeated Values is set to No. Remove line when blank is checked and
the Print When expression field is blank.

The following is untested but should get you pointed in the right direction.

For the field, use the following expression:

IIF(_PAGENO > 0,"Continued from previous page. ","")

Check the "Remove line when blank" option.

Hope that helps,

Dennis Longfellow 2005-09-21 14:32:16 UTC I have one correction to make to the following post>

Post by Brian Hiatt
At the top of the detail band I have a field of text "Continued from
previous page. ". I have it set to print when detail overflows to new page.
Print Repeated Values is set to No. Remove line when blank is checked and
the Print When expression field is blank.

The following is untested but should get you pointed in the right direction.

Put the following in the Print When expression for the field:

Check the "Remove line when blank" option.