>>>On a report that should take 4 pages, a 5th page comes out with just a page header.
>>>This scenario happens with random reports of varying pages. Other times it works fine.
>>> Since I do a count on the number of pages and show "Page 1 of 5" this is a problem since I can't just throw away the last page.
>>>
>>>Has anyone ever seen this problem or have a resolution for it?
>>>
>>>
>>>Chris
>>
>>Chris, check the height of your page-footer, group-footer and report-footer bands. It may be that you have just enough 'blank' space to tip the report over to one more page.
>>
>>HTH
>>Barbara
>
>Does page 4 have stretching fields that approach the bottom? The report writer will often start a new page like that when it doesn't really need to. I have never found a solution. I work around it using non-stretch fields.


Barbara and Brett,

Thanks for your responses!

I don't have any stretching bands and all detail bands are empty but I
did find that removing the page footer prevented the extra page.

I found out a few things and came up with a work around that you may find useful:
If a page prints with no detail info the record number of the table supplying the
detail band info will be the same at the end of both the last and second to last
pages.
I have added to my page counter function a record number monitor as well.
This function is called in the page footer and checks to see if the page incremented
and the record did not. If this happens, I do not increment the total report pages
counter.
IF ThisPage > LastPage AND LastRecord <= ThisRecord
* --- This is the last page and it's a bust, don't count it
ELSE
total pages = _PAGENO
LastRecord = ThisRecord
ENDIF

I haven't implemented it yet but hope I can stop that last page with _PEPAGE but in the meantime
I can just throw it away and have an accurate "Page 1 OF 2" section.

Thanks for your help