Print Page | Close Window

Page Footers will Not Stay at the Bottom

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8066
Printed Date: 30 Apr 2024 at 6:08am


Topic: Page Footers will Not Stay at the Bottom
Posted By: ahmadhasib
Subject: Page Footers will Not Stay at the Bottom
Date Posted: 20 Oct 2009 at 10:52am

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?


Replies:
Posted By: lockwelle
Date Posted: 20 Oct 2009 at 12:29pm
you can try using same logic that is in the suppression formula to suppress each field/label in the PFa, and then select the Suppress Blank section.  It is worth a try.  (Probably will need to remove the suppression logic for the section)
 
HTH

Posted By: ahmadhasib
Date Posted: 20 Oct 2009 at 12:31pm
I've tried that as well, and it brings PFb and PFc up to where the details are.

Posted By: DBlank
Date Posted: 20 Oct 2009 at 1:14pm

Just to verify here.

You definately are using the PAGE footer and not Report footer, correct?

Posted By: ahmadhasib
Date Posted: 20 Oct 2009 at 2:13pm
yes, im using page footer

Posted By: DBlank
Date Posted: 20 Oct 2009 at 3:02pm
THis is strange as I cannot replicate what you are describing at all. If I add  aPFa, PFb and PFc they always stay at the bottom of the page.
Here is another option though. INstead of conditionally suppressing PFa, conditiaonlly suppress each of the fields that reside in it and then mark the section as suppress if blank.


Print Page | Close Window