I'll try to illustrate this as best as possible. Currently my report page has 3 Page headers, Details Section, and 3 Page Footers. Currently no sections are supressed. Here is an example of what it looks like (Imagine the 7 vertical lines being the length of the page):
| Page Header a
| Page Header b
| Page Header c
| Details a
| Page Footer a
| Page Footer b
| Page Footer c
Currently, the Page Footer is automatically being set to be displayed at the bottom of the page (right above the bottom page margin)
If I want to suppress "Page Footer a" by going to Section Expert and checking the box that says Suppress (No Drill-Down), here is what the page ends up looking like:
| Page Header a
| Page Header b
| Page Header c
| Details a
|
| Page Footer b
| Page Footer c
Page Footer b and c are still at the bottom of the page.
What I want to do is supress it using a formula. When i enter in the formula and the section gets supressed, here is what the page looks like:
| Page Header a
| Page Header b
| Page Header c
| Details a
| Page Footer b
| Page Footer c
|
The Page Footers are no longer at the bottom of the page and they appear right after the details section. I want the design of the page to have the page footers at the bottom of the page at all times when 'Page Footer a' is being suppressed using a formula (as it does when I ONLY check the check box).
How can I do this?