Build Custom Reports in Magento

I need to create some custom reports off data that will be collected from two modules, one called Sales Representative Pro and another called Advanced Custom Fields. I know that we need to see sales by rep by date and be able to see the details of each order that the rep is getting credit for (so that we can see the categories, selling price and not have shipping and tax included). - Revenue by Zip Code - Revenue (w/order detail) by group (ie: wholesale / retail/ international) - A full report with all the fields below and totals at the bottom: Order # Customer # Date Billing Name Billing Address Shipping Name Shipping Address Phone email Sales Rep (from custom extension Sales Representative Pro) Coupon Code Referred By/New Referral: (Custom field from Advanced Custom Fields extension) Product SKU Product Description Quantity Selling Price Total Price (And all numeric fields total at the bottom of the report)