Skip to Content
0
Former Member
Sep 26, 2008 at 12:26 AM

XL Reporter Creating Page breaks when group subtotal changes

25 Views

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.