Printing in page footer on change of group

[PhilipOfOrange]

I am designing a statement printing report for use with pre-printed forms. I want to be able to print in boxes on the bottom of the form (page footer) when I hit the end of the detail items in the customer number group. My thought is to suppress printing of the report footer objects except for the last page of the statement for the given customer. How do I detect when I have printed the last detail item for the customer in the formula that will allow the object to be printed.

Thanks,

Phil

 

[rogar]

Put the bottom-of-form stuff in a {Customer_Number} Group Footer. In the Section Expert for this section, check "Print at Bottom of Page" and "New Page After"

 

[PhilipOfOrange]

The problem with this approach is that it would allow the detail to run down into the area of the pre-printed form reserved for the summary information (instead of to a second page) when there was sufficient detail to cause this. That is the reason for the page footer, which would always "reserve" this area, even when not used.

 

[rogar]

Ok, suppress the report footer boxes on the conditions:
Not OnLastRecord and ({Customer_Number} = Next({Customer_Number}))

 

[PhilipOfOrange]

Thank you. That was what I was looking for.