The Sales Report is designed to exactly that, report sales. Reporting based on attributes of a given product is completely different, logically speaking. Without getting into the nitty gritty, what you're looking for would require a complete rewrite to logic at work in building the report.
That's a deliberate decision. The Sales Report queries are massive. If you don't specify a range you are very likely to hang and possibly crash your database. Unless things have changed since I last touched the code, there's actually a max date range limit hardcoded into it, to avoid screwing yourself. :)Also, one thing that always bugged me was there is no 'forever' option on the sales reports. I can pull a sales overall report by day, week, month, and year... but there is no 'forever' option to show all sales reported for the entire time I started running my store up to today. That would be incredibly useful. Especially given the option above... say I wanted to see how many XL's I've sold since I started the store.
Can someone clue me in? Is this possible? Or can it be?
Bookmarks