Custom Sales Report for Zencart

Hello, What we need is a custom sales report system for our zencart admin panel. The layout of the sales report is such that there is a separate table for each category. Within each category table a list of products will be down the left side. Then, another 6 columns follow the products column. These 6 columns are the size attributes of the product. There will be one column at the end of each table totalling each row up. Please read on for clarification... The system needs to collect all orders from the database for a given month. These orders must then be sorted by category. Each product in each category must be listed in the first column with the number of products for each size of that product displayed in the corresponding columns. Each row (each product) must be tallied up and the total displayed at the end of that row. For each category table the rows must also be tallied vertically with a grand total for the table and percentages for each column below each total. Most of the work for this has already been done. The code already displays the information in the correct layout and format. The only problem is the initial query joining together various tables to collect this information. Once the query is correct the rest will work properly. Upon choosing a winning bidder I will provide all files and information necessary to complete the job. I have uploaded a screenshot of the current layout once the script has been run. Please, only serious bidders with zencart experience.