D
DEW
I have a report that runs invoices. I recently fixed the group footer to the
bottom of every page (thanks to help from this website), but now I'm having
another problem. I have an invoice that has a lot of line items and covers
two pages. My group footer (where the invoice total shows up) shows up on
the second page where it's supposed to, but extra detail lines don't. This
particular customer's invoice lists all the line items (14 in total) and the
last 7 or 8 run into the space where the footer would be if it was only a
one-page invoice. Meanwhile, on page 2, the customer header and footer
appear, but with an empty detail section. I tried working with page breaks
and counters but nothing happens. I'm wondering if the code for fixing the
footer position is giving me the problem.
The function I used to fix the position of the customer footer is as follows:
Function setGrpFtrLoc(Rpt As Report, GrpFtrLoc As Double)
GrpFtrLoc = GrpFtrLoc * 1440
If Rpt.Top < GrpFtrLoc Then
Rpt.MoveLayout = True
Rpt.NextRecord = False
Rpt.PrintSection = False
End If
I call the funtion in the Customer Footer Print event:
=SetGrpFtrLoc([Report],5,[DetailCount]) (where 5 is the number of inches from
the top of the page where I want to fix the footer). This works for all
single page invoices.
I am losing my mind trying to fix this problem! Any help would be
appreciated.
Thanks.
bottom of every page (thanks to help from this website), but now I'm having
another problem. I have an invoice that has a lot of line items and covers
two pages. My group footer (where the invoice total shows up) shows up on
the second page where it's supposed to, but extra detail lines don't. This
particular customer's invoice lists all the line items (14 in total) and the
last 7 or 8 run into the space where the footer would be if it was only a
one-page invoice. Meanwhile, on page 2, the customer header and footer
appear, but with an empty detail section. I tried working with page breaks
and counters but nothing happens. I'm wondering if the code for fixing the
footer position is giving me the problem.
The function I used to fix the position of the customer footer is as follows:
Function setGrpFtrLoc(Rpt As Report, GrpFtrLoc As Double)
GrpFtrLoc = GrpFtrLoc * 1440
If Rpt.Top < GrpFtrLoc Then
Rpt.MoveLayout = True
Rpt.NextRecord = False
Rpt.PrintSection = False
End If
I call the funtion in the Customer Footer Print event:
=SetGrpFtrLoc([Report],5,[DetailCount]) (where 5 is the number of inches from
the top of the page where I want to fix the footer). This works for all
single page invoices.
I am losing my mind trying to fix this problem! Any help would be
appreciated.
Thanks.