Different Page Header at the End of a Report

[jemsmom]

My report (Crystal XI) has 2 groups - grp 1 provider reporting group and grp 2 provider. I'm using the New Page Before in the section expert in group 2 to print each provider records on separate pages. I now would like to place a crosstab at the end of each provider group but I want it to be on a separate page between the provider reporting groups and I also want to use a different header.
Is this possible? Any help is greatly appreciated.

 

[lbass]

I'm confused by this:

to place a crosstab at the end of each provider group but I want it to be on a separate page between the provider reporting groups

A crosstab at the end of each provider group would result in multiple crosstabs within Group #1, at the end of each Group #2. Or do you really mean you want a crosstab at the end of Group #1?

-LB

 

[jemsmom]

Yes I do want it at the end of group 1. I apologize for the confusion.

 

[lbass]

Insert a group #1 footer for the crosstab and format it to "new page before" and for "new page after" go into the x+2 formula area and enter:

not onlastrecord

For a different page header, insert a page header_b section with the desired fields.

Create two formulas:

//{@true} to be placed in GF1 section containing the crosstab and suppressed:
whileprintingrecords;
booleanvar flag := true;

//{@false} to be placed in GH1:
whileprintingrecords;
booleanvar flag := false;

In the section expert, select the page header_a containing your usual page header field->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true;//note no colon

Then select the page header_b section (crosstab headers)->suppress->x+2 and enter:
whileprintingrecords;
booleanvar flag;
flag = false;//note no colon

-LB

 

[jemsmom]

lbass

I tried one more time and I no longer get a blank page. To correct it In the group header I had suppressed the false formula and once I suppressed the section I no longer have the blank page and my report breaks everywhere I want it to. Thanks once again for your time.