Hi Jen/Eric

Yep, your two problems are connected all right.

First, "remove line if blank" in a page footer *does* work, although possibly not the way you think it does. I would go into this if I had time and if it were germane to your issue...

There are about 20,000 other things I could tell you about this report that might or might not need adjustment to kludge exactly the look you have in mind. I started doing it and writing a list of instructions, but when I got to instruction #12 I just stopped.

The plain truth is this: what really isn't working is something that was added in VFP 8 reports: that's the ability to make page footers a non-constant band height. I'd say it's "working as designed" or it's not "working as designed" if I knew what the designers were thinking when they added this, but I truly do not have any idea.

There are a *lot* of reasons why this report is especially confusing to the limited intelligence built into this "enhancement". See above, I started trying to figure out appropriate kludges and writing out directions, and gave up.

IMHO the right thing to do here is make *one* change: set the page footer to constant band height. Close up the page footer to use as little extra space as possible on the non-last pages. If you can live with a little empty space on the non-last pages, where the footer exists on the last page, I believe you should otherwise see exactly the behavior you're looking for with the line and so on.

[Irrelevant aside: frankly, I was just happy to see that we didn't make it any worse in VFP 9, and that you'd see exactly the same behavior in both SET("REPORTB") 80 and 90. <g> When we looked at page footers with non-constant height in 9, we concluded it was not a fixable thing as implemented/ conceived.]

Hope this information/advice helps you, or somebody else, sorry it isn't better news.

And for other people reading: there are certainly some reports in which non-constant band height will function properly for page footers, don't get nervous and stop using them in reports that are successful for you. Just realize that they will not, and cannot, always "just work" with all the various types of stretching, floating, potentially suppressed content that may exist in a report. When they don't, they don't.

>L<