I’m beginning to design a salesperson report and I wanted to reach out for help to find the most efficient way of handling this. Basically, in our accounting system, each of our customers has an associated Salesperson (coded with Salesperson ID). I would like to build a jet report for a salesperson that has a different tab for each customer they represent. For example, if Salesperson A had customers 1-10, I’d want 10 tabs, one for each customer.
The issue here being that I want the report to automatically look for new customers with that Salesperson ID.
I know how to build a table that shows a salesperson’s current customer list, but I don’t know how to take that into separate tabs and report from there
Sales Person Report - Multiple Tabs