For now I figured out a way around my optimization issues.. my client really only needs to see monthly summaries, which works fine.

I also added the ability to select sales by zone (state) for tax purposes. If you want to integrate this, I've attached a patched version of the module. I took the reports module from today at 12:01 1/25/08.