Page Footers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a report with Quote information. The quote may have detail information that spans more than one page. I need total information, tax, and subtotal in the same location everytime so I figured I would put this info in the page footer.

If the report spans multiple pages I need this total information to only show up on the last page. Currently it will show on every page. Is there a way to program page footer info to only show if on the last page

I can't use the report footer because then the information will be in all different locations depending on how many detail records there are

Thanks
 
Brian:

Assuming that you've got a group header and group footer for each quote.
(If you don't, then create one based on say the Quote ID; there doesn't have
to be anything in the header or footer in particular, you just need them to
fire before and at the end of each quote).

Then all you have to do is add a little code like this which measures
whether you are within a quote or at the end of it.

a.) Add a variable Dim boolInQuote as boolean to the report's module
declarations section
b.) In the group header's On Print event, add: boolInQuote = True
c.) In the group footer's On Print event add: boolInQuote = False
d.) For the page footer's On Format event add code like this:

If boolInQuote = True Then
Me.PrintSection = False
Me.MoveLayout = True
End If

That should do it.
 
Back
Top