I have a report that displays A Sales Persons name, the stores they sell to and what was sold to the specific store. There is a one to many relationship between Sales Person -> Store and Sales Person -> Item
My issue is that on my report I have the Sales Person Name in the SalesPerson Header, and I have a group by on this.
In the Detail Section, I have the itemName, and itemQty - but the report shows double store info instead of just one
Meaning I get this on the report
Sales Person A
Store # 1
Baseball 4
Store # 1
Cap 5
Instead of showing
Sales Person A
Store # 1
Baseball 4
Cap 5
I am sure this is something small that I am missing but I can't seem to figure it out.