Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Page Footers at bottom of page... 2

Status
Not open for further replies.

jcrawford08

Technical User
Nov 19, 2008
71
US
I have a basic checklist report and am having some issues with page footers. The report only has GH1 - details - GH2(supressed, and then I have three page footers:

PFa has a caption indicating additional data following, and is suppressed where totalpagecount<>pagenumber

PFb has a signature box in it and is supressed where pagenumber<>1

PFc has the data date and pageNofM on it for reference (therefore I'd like it to print at the bottom of each page)


The problem is that on the last page, the detail section can generally carry over to only half way down the page; when this happens, then PFc prints in the middle of the page, just below the details...

It appears this may be similar to thread767-1164217, but I couldnt find an answer to it....
 
Page footers always print at the bottom, so I'm wondering whether you are really viewing the page footer on the last page or whether it is in a report footer section.

-LB
 
If you right-click on the margin of a section, and then choose Section Expert, one option is 'Print at Bottom of Page'. But as lbass says, this would not apply for a page footer.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
That was my understanding too; however, I beleive it has to do with my having three page footers to it; it allocates the space for the other two page footers, even if they are supressed (I even tried setting up a formula for the underlay following sections that would allow for underlaying when that given section was supressed, and nadda)...

Perhaps, I can set the first two up as report footers with the supression codes mentioned, then that will allow the one page footer I would like, and maybe that will work...

However, that still doesn't explain why it isn't allocating the space from the bottome up...

I've attached the report and some screenshots, take a look; from my perspective, it appears as though it is treating the page footers (at least on the second page) the same way it should be treating report footers...

Let me know what you think...
 
 http://www.mediafire.com/?g7w1c2e8wdx9f
I wonder if you could use group footer sections instead and format them to print at the bottom of the page. Depends upon whether the group logic corresponds or not.

-LB
 
probably not, we have several tasks that are set up as groups so we can display in a particular order, so it would repeat far too often to use the group footer as a page footer in this case...

Not in word only, but in deed also... 1Jn3:1
 
You cannot eliminate the page footer space when using conditional suppression. You could handle your issue by using the page header section instead of the page footer section. You would stretch the page header to page length, and place the text box at the bottom. Then format the page header to "underlay following section".

Then you would have to add formulas to count the visible lines on the page:

//{@pageheader formula):
whileprintingrecords;
numbervar cnt := 0;

//{@accum} to be placed in detail and any visible group sections:
whileprintingrecords;
numbervar cnt := cnt + 1;

Then go into the section expert->new page after->x+2 for each visible section and enter:
whileprintingrecords;
numbervar cnt;
cnt = 42 //or whatever line count that you want to trigger the page break

-LB
 
I am still confused though, as to the positioning of the final page footer; page footers should be allocating space from the bottom up, not from the end of report down... right?

Therefore, the final page footer (in this case PFc) should always print at the bottom of the page - irregardless of conditional supressions set up on earlier page footers(PFa and PFb); I'll try the work-around, but I guess I'm just not seeing why it isn't working the way it is set up now...

Thanks for all your help lbass!

Not in word only, but in deed also... 1Jn3:18
 
The only thing I can think of, is that it allocates from the bottom up the TOTAL amount of space in the combined page footers(PFa, PFb, and PFc)... then when the conditional supression comes up, it simply pulls PFc up to where PFa was set to start...

I may be a little slow, but I think I just figured it out :)


Thanks again lbass!

Not in word only, but in deed also... 1Jn3:18
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top