Use footers not appends for regular data
It really does depend on how irregular the records are. You can solve the first issue by using footers instead of appends. This would work 100% if every page had had data that matched very template. Otherwise, Employee A would end up with footer data from the following record of Employee B.
To avoid this, you can use four approaches:
1. Guru traps.
2. Multiple passes joined on the page number.
3. Grab one big memo field from a single template and define some calculated fields.
4. Using Monarch v10, make the detail template at the bottom of the page, and turn off append templates at the next occurrence of a page header template.
It's largely a matter of personal preference - (3) is usually a quick and efficient route to prototype the data with.
MONARCH Ã | ß | Ň | Ø EXPERTS