Creating a new report

j.belanger

I have a report under my "Sales Reports" which tells me the "Average Inventory Usage" which is a bit useless to me at the moment. I am looking for a way to either alter or create a new report with the following information.
1. Item No.
2. Average Inventory usage
3. Filter by a specific date range (3 months) prior to current date
4. shelf/bin no. (either all, or specific locations)
5. qty on hand by location >0

If anyone has any idea what the code should be for this, please let me know as i would greatly appreciate it..

j.belanger

We also use jet reports which i'm not that good in either, but figured i would throw that out there too for more options.