Widowed group footers

[Former Member]

I have a report with two levels of grouping, plus subtotal to inner group and a grand total for outer group. After the inner group is totaled then a new page is to occur, except of course if it coincides with the outer group. Ditto re the grand total.

I've faithfully followed some articles regarding widowed group footers. BUT THOSE ARE RELATED TO ONLY SINGLE GROUP. FOR MULTIPLE GROUPS THERE ARE NO ARTICLES.

But it just doesn't seem to work. Is there anyone out there who has some experience with using formulas to handle such formatting situations? If so, I could definitely use your help and advice.

[Former Member · Accepted solution]

Hi,

Can any one help me out with this issue....

[Former Member · Accepted solution]

In the formula for New Page After for the group footer, put the following:

Not OnLastRecord

This should resolve the problem.

-Dell

- A computer only does what you told it to, not what you <em>thought</em> you told it to!

[Former Member · Accepted solution]

Hi,

The mentioned answer is not working. I dont think so it will work for widowed footer even for single group.

Any way thanks for trying to help me.

[Former Member]

I don't know that I quite understand what the problem is. Are you just trying to ensure that the groups dont' get split up on different pages?

Or are your formula's adding extra information because it includes the information that is in the footers?

Or is it something else?

[Former Member]

Hi,

Your first question is correct.

Group footer is coming alone in the next page. I dont want widowed group footer.

Thanks,

Vijay