I would greatly appreciate a suggesting for controlling page breaks in an XL Report SAP Business One 2007 A.
I have created an XL report for Sales Person commissions. The reports lists invoices and credit memos for a given date range, groups by sales person, then by customer, subtotals by customer, totals by sales person. I need to page break everytime the total by sales person changes. I've tried page breaks in excel but the report will not consistently page break as i need it to. Any suggestions are welcome.