Custom report for Magento

Need to create custom report, that would display all products bought during a chosen period and also calculate summaries. Report output example can be found in attachment. General requirements: o Only orders with "Complete" status must be included in this report o Product costs must be taken from orders, not product attributes, as prices could change o Every product must be presented as a single line in report with all summary values as shown in example o Standard "Export to" option must support exporting to excel. Report will have following controls: o From:To Dates o Author - as multiple select o Copyright - as multiple select o Genre - as multiple select o Agent - as multiple select o Sub-agent - as multiple select o Book Name - as multiple select Only Dates are compulsory, all other values basically just narrow down displayed results if set. Report output will have following columns: o Row number o Author - product attribute (dropdown) o Copyright - product attribute (dropdown) o Genre - product attribute (dropdown) o Agent - product attribute (dropdown) o Sub-agent - product attribute (dropdown) o Book Name - product attribute o From:To Dates - values from report settings o Times Sold - amount of times this product was sold o Total - Total this product was payed for during chosen period of time o Total excl. Tax - taken from o Tax o Royalty % - product attribute o Profit - this is Sub-Total minus Royalty o Royalty - this is Sub-Total*Royalty % Additional requirements: o Report name in admin menu should be: "Total sold" and should go under Reports > Sales right under Sales Report. Name should be declared for translation. o Please include a TOTAL row in report at the very bottom. Similar to how other reports do this. I need to see totals only for the following columns: o Times Sold o Total o Total excl. Tax o Tax o Profit o Royalty o Columns names, if they are not attribute names, must be declared for translation!