We run an osCommerce site that sells activities (instead of shippable products).
We need to be able to analyze and get reports of our orders which includes our commission, our taxes and our fees for each order. And we need to be able to create a report based on certain date ranges and based on vendors.
Basically what we have in mind is two different reports. One that can output our net profit and the taxes we owe based on orders in a date range. The other report is to find out how much money we send to a vendor on a given date range.
Please note that the site is already built and has been fully functioning (and taking orders) for a long while.
All we really need is a report that takes existing variables in the database and organizes them by selected dates for viewing purposes.