Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Want Summary Band at bottom of page.
Message
 
À
05/09/2008 22:11:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01345297
Message ID:
01345632
Vues:
47
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform