Creating an inventory projection report with date range

[Landmark]

We are looking for a way to create a comprehensive product inventory report that can be searchable within a specified date range. We use this information for print projections based on previous seasonal demand periods. I have seen the advanced reports extension and it does many things we need, but doesn't appear to be the solution for this need. The best thing I have seen so far may be exporting files to a database configured the way I want. Any ideas?

[Landmark]

Just want to say that the development team handled this like a boss!  Thanks.

[abantecart]

I can suggest to look for third party reporting tool.
http://www.capterra.com/sem-compare/reporting-software

You can install tool on your server and connect to your AbanteCart database.