Tuesday 18 February 2020 @ 8:24 am
If you have two group levels and you put a “New Page After” on Group Footer 2, you will find that Group Footer 1 gets orphaned onto it’s own page. To fix this put a “New Page After” on Group Footer 1. Then instead of putting the same check mark into Group Footer 2 you use the following condition on the “New Page After” property:
{Group1.DatabaseField} = Next ({Group1.DatabaseField})
Of course you use your own database field from Group 1 in the formula. This prevents Group 2 from doing a page break on the last record of the group. On that record the next value for Group 1 is different, so the page break is handled by Group 1.
(For examples of my most popular formulas, please visit the FORMULAS page on my website.)






