>Boss man wants a count to appear on the last page of the report
>
>Due to the vagaries of the data gathering requirements on this report, I cannot use a summing field for the count, I have to run another query and pass the count into the report as a variable. Since the count is in the Page Footer, it is showing up on every page.
>
>I just need it to print on the last page. Any suggestions?
Add a Summary band, but all the objects will appear just at the botom of the last row. If you want something to be printed in the last page footer band you must use this:
1. Add that in the page footer. Set the Print When to be RECNO("Alias") = RECCOUNT("ALIAS")
That is valid ONLY if you base your report to a CURSOR and that cursor has NO ACTIVE INDEX opened
2. Add that in the page footer. Set the Print When to be _pageno = m.lnTotalPages
Then You should run the report that way:
lnTotalPages = 0
REPORT FORM ..... TO FILE NULL NOCONSOLE
lnTotalPages = _pageno
REPORT FORM ..... TO PRINTER PROMPT PREVIEW
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.