Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael Gill
  Where is Michael Gill?
 Flora
 Illinois - United States
 Michael Gill
 To: Mike Lane
  Where is Mike Lane?
 Barrie
 Canada
 Mike Lane
 Tags
Subject: RE: Report summary on bottom of last page.
Thread ID: 22702 Message ID: 22745 # Views: 18 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Thursday, April 24, 2003 4:34:53 PM         
   


> > > I am creating a report which is an invoice. At the bottom, I need a summary which contains things like the subtotal, total and so on. This needs to appear at the very bottom of the last page. How can this be done? If I use the "Page Footer" band, it will appear on every page. If I use the report summary band, it will appear on the last page, but not necessarily on the bottom. How can I force the report summary band to the very bottom of the page?
> > >
> > > http://www.arsindelve.com
> >
> > How about putting fields in the page footer band which only print when RECNO() = RECCOUNT() ?
> >
> > Cheers,
> > Jamie
> > jamie.osborn@foxite.com
>
> I gave that a shot initially, however in a page footer band (and report summary band), the checkmark that says "Remove entire line if blank" is unchecked and disabled so they have no effect when empty. Great idea, though. Thanks.
>
> http://www.arsindelve.com

The trick is to put all of your data in a group and use the group footer to print. See, the group footer won't print until the group is done printing. So you can group your entire print job on something that's indisputable like .T. = .T. (I'm not sure if that will work. I use EMPTY(fieldnamethatsalwaysfull) = .F. but you get the idea.). Then viola! You have your end of report footer.

---

www.foxite.com - The Home of the Visual FoxPro Experts

COMPLETE THREAD

Report summary on bottom of last page. Posted by Mike Lane @ 4/24/2003 3:14:40 AM
RE: Report summary on bottom of last page. Posted by Jamie Osborn @ 4/24/2003 5:47:53 AM
RE: Report summary on bottom of last page. Posted by Mike Lane @ 4/24/2003 3:42:15 PM
RE: Report summary on bottom of last page. Posted by Michael Gill @ 4/24/2003 4:34:53 PM