Report based on vendors

I want my vendors to pay affiliates for sales of their products, but right now I cannot run a report that breaks down a month’s affiliate sales by vendor.