Biggger is not always better and that is especially true with reports. Using filters appropriately will help refine your report. so that you will only see the relivent data. Here are some example Filters that will help you narrow your search:
Filter: On Hand QTY is greater than 0
What it does: This filter will not include inventory that has been sold, donated or returned.
Filter: Sold Date is Before_____ AND Sold Date is After ____
What it does: Giving a date range will allow you to search through a smaller field
Filter: Is Consigned is True
What id does: This will only search items that are consigned and not store owned. You can also change this to false to view store owned inventory only