My Sales Order Acknowledgment works exactly like Dave’s description. There is a page break that makes the terms and conditions go on a dedicated page at the end of the report. The report has a query source for the verbage that pulls from a table called termcond in my custom schema.
To make it more modular, each row in the table stores the text for an individual term or condition. There is a Category (like Sales or Purchase), and a term/condition description like (Warranty, Returns, Cancellations, etc…). The query source for the Sales Order Report is select * from termcond WHERE termcond_category = ‘SO’ The Report xml has a Group section that formats all of the applicable termconds. The group section was definitely the fiddly part for me.
I will post the Report xml and table SQL here later, I just need to export it and remove any sensitive info.