I need to print a multi-page report. On the bottom third of the last page, I need to print a bill.
I have a repeating frame right before the last frame which contains the bill data. I have code stored in formula columns that calculates the number of blank lines to print in order to push my "bill" frame down far enough on the last page to print in the exact spot each time, regardless of how may detail lines are printed above.
I tried to use the value in the formula column in a WHERE clause but it does not seem to be set to any value at that point.
I also considered putting the "bill" frame in the footer but then I want previous pages to be able to print detail lines where the footer would otherwise print.
Is there any other method for forcing absolute positioning of a frame on the last page of a report?
I have a repeating frame right before the last frame which contains the bill data. I have code stored in formula columns that calculates the number of blank lines to print in order to push my "bill" frame down far enough on the last page to print in the exact spot each time, regardless of how may detail lines are printed above.
I tried to use the value in the formula column in a WHERE clause but it does not seem to be set to any value at that point.
I also considered putting the "bill" frame in the footer but then I want previous pages to be able to print detail lines where the footer would otherwise print.
Is there any other method for forcing absolute positioning of a frame on the last page of a report?