>On my reports, how can I make the Summary Band flush with the BOTTOM of the last page of the report? It will mean having an unknown amount of white space from the last detail record. The last page may have only 2 or 3 detail records, or it may fill 75% of the page. Either way, I still want the Summary Band all the way at the bottom of the page. The Summary Band spans about 1" of vertical space on the report.
>
>I have tried putting it in a Page Footer, and setting the "Print When" of each element to make it print only on the last page, but when you do it hat way, the space is allocated at the bottom of every page, and I don't like that. (If haven't tried this method since upgrading to VFP9, so maybe that behavior is different now, but I doubt it.)
If you don't have any "stretchable" fields on the report, or any fields marked to remove when blank, you can do this... Create a report variable to count the detail lines as they print. Add a field to the report just above the the summary information, but still in that band. Use an expression something like this: REPLICATE(CHR(13), 99-rnLines). rnLines is the report variable that counts the lines and 99 is the maximum number of lines that fit on a full page. Be sure to mark it to stretch and mark all the other fields to float.
As I said, this only works when the height and position of everything on the report is static so you can assume the total number of lines.