Detailed Reporting needs

We have several customers that require us to report on a regular basis that shows all products on their store, when they were created, last time ordered (if at all), how many orders and quantity in the time period and then filter by product category or location shipped. We are currently pulling Inventory report, product report and order report to get all these things together and still having to reference the site for a few items.