Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force reports summary to bottom of page???
Message
 
To
09/01/2003 21:36:19
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00740154
Message ID:
00740283
Views:
7
You are correct in assuming the report writer is making room for the entire page footer. When it decides how much room a particular band needs, it only looks at the objects in the band. It doesn't evaluate any "print when" expressions or "remove line if blank" expressions.

What you could attempt to do is define a group with the expression of EOF(). Then create a report variable that counts the detail lines on a page, resetting it for each page. Put your totals in the Group Footer and mark them all as float. Just above all the totals, place an object on the report with the following expression:

REPLICATE(CHR(13), ??-rnLines)

Replace the "??" with a number that represents how many detail lines would normally fill the page. Make this object wide enough to go across the whole page and mark it as stretch.

Of course, this concept only works if the detail section is a fixed length and doesn't have any stretchable fields!!

Cathy


>I have some summary data that I print at the end of one report, and we like to see it at the very bottom of the last page. If I place the data in the Report Summary Band, it prints immediately after the last detail line, which could be close to the top, or in the middle, or near the end. Point is, you never know where it will fall out.
>
>I tried putting it in the Page Footer, with some Print When logic that will only print it on the last page, and this does work, but I get a gap at the bottom of all the pages, like it is making room for it but just not printing it.
>
>Any ideas?
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