Analytical reports already have automatic page breaks with repeating header. But how can I make it insert the break so that sections remain whole. By “section”, I’m referring to Assets, Liabilities, and the subsections within such as Fixed Assets or Long Term Liabilities. Our sections are represented simply with a row inserted using line type “caption”. Then there is “total” row at the bottom of each section.
I know a precise break location can be set but that’s not what I want. We have multiple branches. Some are very active with lots of subaccounts, while others are nearly dormant and use almost no subaccounts. I don’t want to see the same page break location for all of them. Those dormant branches won’t need a page break at all. I’m hoping there’s a way to make Acumatica dynamically insert a page break based on the row type. If all rows between “caption” rows can’t be displayed, then it would insert a break and begin page 2 on the next caption row.
