We are in need of a report to quickly and accurately track commission sales of a few products for b2b sales for our locations.
If canned Retail or Analytics reports don't suffice then I would suggest a route we took. I just created a routine to pull all daily activity via the API. Taking those results and pushing them into a local SQL database. Makes it easier to slice and dice things and get at exactly what we need.
Although if you have the Analytics package added to your subscription, I'd imagine you could create a report that would calculate things out, export the results to e-mail, etc.