Repeat group footer on each page for crystal report 11.5 1

[PointProg]

My report is broken down to two groups. The second group I want to place a footer on each page. The first group does not have set limit of pages, so it could be 1 page or more, which means I can not do a page number formula. I know you can do this for group headers with checking a box to repeat group headers on each page, but there is nothing for footers. I am open to any suggestions, thanks.

 

[lbass]

I think you should be able to insert a page footer that is conditionally formatted to suppress except when the current group is the group in question. I'm assuming you mean the second of two instances of the same group? If so you should be able to conditionally suppress a page footer section using a formula like:

{table.groupfield} <> "Second Instance"

-LB

 

[PointProg]

I got some ideas from what you said and other forums on this site but I still didn't have any luck with this. I am pretty new to crystal report so I may have taken you answer a different way that you intended. I will try to re explain my situation in a little more detail to see if I made a mistake in my first post. I went into the group name field and I insert a group for a table called Main.Salescode (Salescode is the field it is sort by), next I insert another group for a table called LocAdd.ID. In my report I have group header and group footer for each table (Main and LocAdd). For Main, there is not a set number of pages because the user data could make this portion mulitple pages. If there was set number of pages for the main I could just put a formula like PageNumber > 1 in the page footer to suppress up to a certain number. I need to be able to put a page footer on the LocAdd portion of this report. I am not sure if the Group Footer can be used for this, because I think this shows up only at the end of the group and not on each page. I think I need to create a formula in the page footer to suppress the footer for the first group and not the second. Is this possible? Or is there another way of doing this or is your answer from before the way to go? Thanks,

 

[lbass]

If you have a group #1 on Main.Salescode and a Group #2 on LocAdd.ID, ALL group #2's will be nested within Group #1, i.e., there is ALWAYS a group #1 value while the Group #2 is being displayed. So is there some large group header #1 that displays on page 1, followed on the next page by group #2. Please explain a little more about how your report displays--what sections are being used and how they relate to the pages in the group#1.

-LB

 

[PointProg]

This is my lay out, I have suppress report header, then page header with info, then a couple Main group headers with subreports in them, next is Loc Add group header. My LocAdd portion is broken down to a Group Header, after the the group header I have a bunch of detail sections with sub reports in them. I want these sub reports, which is loc add information to have a footer on the pages. I did the detail sections because some of the sub reports had mulitple additions depending on user data, so this way all the entries would show up for the giving sub report. Not sure if that was the best way to do this, but it work with multiples. Next is the group footer for Loc Add, then group footer for Main, then report footer, then page footer. I hope this helps and I explain it ok, thanks.

 

[lbass]

If you only want the page footers on the pages where the detail subs are executing, then try this. Create two formulas:

//{@false}:
whileprintingrecords;
booleanvar flag := false;

//{@true}:
whileprintingrecords;
booleanvar flag := true;

Place {@true} in your main report Group header #1. Place {@false} in the detail section of the main report. Place the fields/text you want into a page footer_a section. Then go into the section expert->page footer_a->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true;

This worked when I tested it as long as I unchecked "Keep object together" (so that the subreport would not be moved to the next page when it didn't fit) or if I inserted a new page after the group header #1 section.

-LB

 

[PointProg]

Thanks for the help and I got it working, I was doing something similar to my report like you stated, but I wasn't putting it in the right spot.