page footer should display on last page in a group

[BHScripter]

Hi:
I have a report which is basically in run of renewal letters being sent to apartment renters. The letter to each renter may be 1 or 2 pages depending on the length of the detail section.

The group is the apartment unit #. The page footer is the letter closing (signature, title of sender, etc.) I only want the page footer to display if it is the last page for each apartment #. I have set the group footer section for the apartment # group to reset page number after but I'm not sure how to indicate a last page in a group condition in a formula.

Thanks much!

 

[hilfy]

Instead of using the page footer, you could try using the group footer. Another option is to use a suppression formula on the page footer that looks something like this:

not NextIsNull({group field}) or {group field} = next({group field})

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[BHScripter]

Hi:
Yeah, I will try the formula route as the group footer option sometimes puts the signature in the middle of the page but the page footer consistently is in the appropriate location.

 

[BHScripter]

When I try the formulas and check them, I get an error that says this field has no previou or next value

 

[hilfy]

Please post exactly what you're putting in the formula. You should be replacing the "{group field}" that I typed with the actual field that you're grouping on.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[BHScripter]

I did put in the group field as a replacement in exactly the place you had group field

 

[hilfy]

You could try breaking the formula down - take out the NextIsNull part and see whether that's causing an error. If it is, please post your formula.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[fisheromacse]

i think it would be easiest to use the group footer and in the Section Expert, check 'print at bottom of page'

 

[IanWaterman]

I have had to build docs using Crystal too and moving page footers has always been fun;-)

The only way I have been able to do it is use a Boolean global var

In groupheader
@Reset
whileprintingrecords;

global booleanvar Pagefoot:=false;

In Group Footer
@Eval
whileprintingrecords;

global booleanvar Pagefoot:=true;

In Page footer suppression formula

whileprintingrecords;

global booleanvar Pagefoot:=false;

This will keep PF suppressed until after Groupfooter has printed

Ian

 

[BHScripter]

Thanks I will give it a try