Orphan Trailing Grand Summary Part

[dwdata]

Hey gang,

Dealing with a little quirky report part issue in FileMaker. I am wondering how other developers deal with this. Below is the use case scenario and attached is a sample file I zapped up.

ISSUE:  I have a simple List Report (Header, Body, Trailing Grand Summary, and Footer). Sometimes, depending on the quantity of records in the found set, the Trailing Grand Summary breaks to a new page with NO BODY ROWS. This is quite confusing to the recipient. It would be nice to have at least one row present in this case for continuity purposes. I am wonder if someone has a slick way to cause that last record to push to the next page if the Trailing Grand Summary is going to be by itself.

If the BODY part was fixed, I could group the records and add a sub-summary (with page break after occurrence) to push the next record to next page. When the body height varies via field sliding this does not work and falls short.

Any thoughts on this would be greatly appreciated. Thanks!

tr_grand.fmp12