Group objects/controls in report so they print together

[PeakH]

I am creating an invoice with two product sections.
The first product section is in the details section like a regular report, but then I have a sub-report in the report footer section that displays a second product section (the two product sections are from different tables). Also in the report footer section I have the subtotal of the first product section, the invoice total, any customer special requests and a "thanks for your business" note.
I don't want the notes in the page footer as our invoices are often more than one page and I only want them at the very end instead of on every page.
I changed the report footer to not stay together, as it is large and often gets pushed to a new page, leaving the first page with a lot of blank space, but now the totals can get separated from the products, or for half the notes to be on one page, and half on the next. What I want is to have the subtotal, sub-report, and invoice total to always stay together, and then for the notes to always stay together when printed.


Is this possible? And preferably without code as I don't have any code experience..

[aytee111]

Use Grouping - add a group by some field, such as customer. Then in your group footer you can specify keep together or not.