Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want Summary Band at bottom of page.
Message
 
To
05/09/2008 22:11:21
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345297
Message ID:
01345632
Views:
46
>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.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Reply
Map
View

Click here to load this message in the networking platform