Sage 100

Sales Order Crystal form. I have lengthy terms and conditions text box printing on the final page of each order in the same section as the order total. Because the text block is so large, it's causing an equally large blank area on the bottom of preceding pages. Is there any way to avoid that big blank space at the bottom of non-total pages?

I've had good luck with making the box smaller (even though it cuts off part of the text), setting format to ""Can Grow"" and putting suppression formula on it.

What group is the text box in?

Page footers are reserved on each page.

I would put it in the group footer of the order. Then it only prints on the final page of the order.

I'll try making the text box smaller and using the 'can grow' function. Thanks for the idea @MarkKotyla

Even if you set the text box to Can Grow, if there is not enough space in the page footer, it will not grow. Page footers do not 'grow'.

Well of course. Thanks @ThereseLogeais

Sorry about that. Just noticed that my ""Can Grow"" was in Details. Unless you can put it in the details and suppress if ""PageNumber <> TotalPageCount or {SO_SalesOrderWrk.SalesOrderNo} = Next({SO_SalesOrderWrk.SalesOrderNo})""?

Maybe create a Page Footer section above the one with the totals, set this section (with the terms and conditions) to underlay the following (totals) section, then set the section suppression to suppress when nextvalue(OrderNo) = OrderNo. That should keep it from printing on all but last page of the order. Finally, in the section expert, while on your new Page Footer section, the right side should have a ""Suppress Blank Section"" checkbox that you should check.

@JimWoodhead modified some forms for me to do this. I can share them with you if that helps.

That would be great!

will email you a download link

Fixed. Thanks to suggestions from @ThereseLogeais and @GregStiles I moved everything to the Order # Group Footer section and this monstrous text only prints on the last page. I'm so happy and the client is ecstatic.