Printing a Report Footer only on the LAST page

You can put EOF() in the print when of all controls in the page footer.

Or you can put the controls in the summary. Then count the records that will be printed. Add blank records so that the summary prints at the bottom of the page.

Guys,

Using your info I tried a couple of things.

First, instead of the EOF or RECCOUNT() check, I used  _pagetotal == _pageno in the "On Entry" line.  it did not work.   Instead, I set up the PRINT WHEN section to have REMOVE LINE IF BLANK and PRINT ONLY IF  _pagetotal == _pageno.

That DID work, but the FOOTER is still "there". At least, the item DETAIL would not print in the FOOTER area, which is a waste of paper.

I AM getting the Footer at the end of the report, and thank you for that.  Any idea how ot use the space it wastes?

Use the option remove if blank.

Or you could put another item there:

I used for example IIF(RECNO() < RECCOUNT(),something,anotherthing)

I also used back in FPW26 (this option is now available in VFP 9.0 FRX) a way to make have the form as invoice and the other half as receipt.

I used something like:
IIF(query.type = 'R', concatenate receipt fields, concatenate invoice fields)

I am not sure when EOF() fires up. Maybe when RECNO is equal or only when more than RECCOUNT().

That's why I use this expression:
RECNO() >= RECCOUNT() && to be no safe side.

I have the option REMOVE IF BLANK checked.  I am still getting the FOOTER area not being used.  There must be something to make it be used unless printed.

I'd try it differently: Make the footer you only want on the last page a group footer, and let the report group by a constant, so the whole report is one group and thus the group footer will only print on the last page.

Bye, Olaf.

I am wondering.  The PRINT WHEN is engaged in my  _pagetotal == _pageno statement prevents printing.  But, the fields are not actually "Blank", just no printting.  Would I have to go further and add:

IIF( _pagetotal == _pageno, Print_var, "") to force the blank line to remove?

menu: Report->Data Grouping
Add Button
when prompted for an expression, type in a constant, eg 0,1,'A', whatever.
put anything from the page footer to the group footer.

Another thing that should be usable for a report footer is the optional summary band.

Bye, Olaf.

Remove line if blank does what it says, it only removes lines that are totally blank. If you have a report label with a static text for example, this is making the line not blank. You'd have to have it's print when also set to only print at the last record.

I think a group spanning the whole report or a summary band fits your needs better and is easier to setup and maintain than a bunch of printwhens and removelineofblank must also be set at each report control or label of a line to really work.

Bye, Olaf.

I am NOT getting the Footer printing on every page now with  _pagetotal == _pageno in the PRINT WHEN field.  I am using Visual Foxpro 9.2

I am still getting the area used for the FOOTER, though, even if blank.  My thought now is to make the fields go blank. (SPACE(0))

And, I need the FOOTER to print at an exact spot, which it will   The summary band will not.

fmoore,

With your problems of blank area and position of the summary band, I again suggest a group footer of a group spanning the whole report. Because: a) it will only print at the end and b) you can position it correctly. It will never appear or even just occupy empty space on any page before the last.

Bye, Olaf.

Is there some way to set up a group footer to print in a particular position.  The regular footer does so, but the group footer appears to always follow the DETAIL band.

Okay I see, the page footer is taken from the bottom margin and the group footer just follows in the line after the group. I remembered, that you could setup the object position to be from the page top or bottom, but the object position can only be relative to the band's top or bottom.

The first thing that comes to mind is adjusting the footer position by adding empty records to the detail band (and NOT setting that to remove line if blank, of course) Then you'll need to find out what number of records will fill a whole page and thus what number of records you need to add blank to adjust the group footer.

Maby you could make the page footer not occupy space by unchecking it's "constant band height", if that is set. I imagene that would help make it shrink if the detail band needs more space and the footer is empty anyway.

Bye, Olaf.

By the way: What was wrong with the summary band you can add as optional band? It's adding a detail band you don't need, but you can set that to zero height. And it will be below the page footer, so it should print at the bottom margin of the last page.

Bye, Olaf.

Maybe you should take a look at ReportSculptor. http://www.report-sculptor.com/

Olaf,  the summary band DOES NOT print below the footer, despite it's position in the report.  It always prints below the last GROUP FOOTER.  It is not a solution, alas, as I need the FOOTER position.  I have a billing statement with large number of details, and I need this FOOTER to print the tear off payment coupon.

Tusharkanvinde, ReportSculptor is very interesting.  Take a while to learn it, however.

I am going to try to make the Footer fields RESET to SPACE(0) to see if I can make them disappear (REMOVE BLANK FIELDS == .T.), but I am more concerned that PAGE FOOTER may design an area not excessable to DETAIL.

fmoore,

Yes, the page footer area is not accessible to the detail band. Remove line if blank does not shrink that area. I see no chance to get what you want.

Bye, Olaf.

Olaf, as it stands, with a 3.458 in required pane, you are right.  for now I am writting off the area as 1) few clients will go to mulitiple pages and 2) it prints just fine on a single page.

FOOTER seems to be a fixed size.  I tested by making the fields in the area just set to SPACE(0) if _pagetotal <> _pageno.  Did not make a lick of difference.  FOOTER is involite.

I am studying more on Tusharkanvinde's suggestion on ReportSculptor.  It appears it can handle a situation this.  Pretty much any situation.

Frank

Besides ReportSculptor, I have advised to add lines to the last record. I feel that is a much easier solution

I would have to spend some time checking the placement of the new 'footer' using that method.  I have found using lines it tends to fail with EXACT placement if you spread it over many printers, each with a slightly different definition of a lines's size..  Remeber, I have thousands of folks and printers using this program.  

Tusharkanvinde, it is a very good suggestion and one i have used before, but I don't think I can rely on it in this case.

That may work as an alternative.