show page footer after a group 1

[NJChris]

I am using Crystal 9 and have a report that can vary in the number of pages returned for each Account Rep.. I need to show a text message in the page footer at the end of each account reps report but because of the varing pages I can not base this on page number. I am trying to have the page footer show after a particular group footer but am having no luck. I tried the following:
//@formula 1 placed in group 1 header
whileprintingrecords:
numbervar x = 0:

//@formula 2 placed in Group 1c Footer
whileprintingrecords;
numbervar x = 1:

and in the page footer suppression formula I put
whileprintingrecords;
numbervar x;
x = 0

and i set new page after for report footer 1c

But this dosn't work. I either get no message displayed on any page or if I change the suppression formula to x = 1 then I get the message on all pages. Any help is greatly appreciated.

 

[synapsevampire]

Group by the Account Rep, right click the Account Rep Group and select Section Expert and select new page after.

This will provide a new page after everyu group, and thus the page footer will display.

If it's just for one specific group, then place the criteria within the X2 next to the new page after.

If you need additional help, perhaps you can post example data and expected output rather than trying to describe it.

-k

 

[lbass]

You could create a formula and place it in the page footer:

if {table.acctrep} <> next({table.acctrep}) then "Your text message"

-LB

 

[NJChris]

Thanks for the replies. lbass, you are brilliant! I have spent so much time on this and obviously was over thinking the issue. Your approach is so simple and direct that I am embarrassed. You certainly deserve the star.