Group footer problem

[UnknownProgrammer]

I have a problem when I have 2 group footers.
I need each group-footer-2 to invoke "new page after" unless it is the last group-footer-2 printed. When it is the last group-footer-2 I need the group-footer-1 to print on the same page and then invoke "new page after" (only in this case). FYI.. group-footer-1 also invokes "reset page number after".

Any help is appreciated.

 

[synapsevampire]

It sounds like you want to leverage the onlastrecord function to determine if the group footer 2 is on the last page.

The GF2 new page after formula should be:

not(onlastrecord)

The GF1 new page after formula should be:

onlastrecord

-k

 

[lbass]

Create a running total {#grp2cnt} using the expert that counts the group #2 field, evaluates on change of group #2, and resets on change of group #1. Then go to the section expert->group #2 footer->new page after->x+2 and enter:

{#grp2cnt} <> distinctcount({table.group2field},{table.group1field})

Or, now that I think of it, I think you could add this formula instead:

{table.group1field} = next({table.group1field})

-LB

 

[UnknownProgrammer]

lbass,

Worked like a charm !!

Thanks