I have this report that I'm developing and need to explore a different approach to grouping on multiple values, I can resort to Sub-Reports but would rather seek the opinion of the experts at EE first. for the sake of simplicity here's the report.
SalesPerson SalesDate ItemNumber SalesAuditor SalesManager
JJ 20120101 ABC123 AA BB
AA 20120102 ABC124 AA AA
BB 20120103 ABC125 BB JJ
JJ 20120104 ABC126 JJ JJ
AA 20120105 ABC127 BB BB
BB 20120106 ABC128 BB BB
I need to be able to group by "SalesPerson" or "SalesAuditor" or "SalesManager" and show their sales activities, the catch is, any of these sales people can play more than one role on a given sale transaction, a sales person can be an auditor or a manager on a given transaction, how do I go about writing this.