I want to add a footer to the bottom of the last page when printing reports can anyone help please.
You have two options you can play with.
A trailing grand summary is easy to add to your layout and can be used to display data after the last record on the last page, but it won't be in the "footer" position at the bottom of your page.
You can put items into the footer and use conditional formats and/or calculation fields to control what is visible so that the footer of the last page displays different info from the regular footer found in the rest of your report. Calculation fields and conditional formats in the footer of the last page, if I remember correctly, refer to the last record so you can use expressions such as Get ( RecordNumber ) = Get ( FoundCount ) to detect that this is the last record.
Retrieving data ...