I am currently creating a report with two pages, the first page is to display records in the database. the second page is just a simple page with static values.

 

So what i need is a page footer for page 1 only and page 2 does not require one.

 

Extra info: Page 2 will static values span across the whole page leaving not space for page footer. so which means even though i suppress page footer 1 but there is still space reserved for page 1 footer on page 2 causing page 2 to overflow to page 3 (which is not what i expected).

 

Can someone enlighten me?