There are two types of reports you can run in the Reports Tab;
Product reports and Customer reports.

Product Sales allows you to generate a report based on the search of 4 product attributes:
Product name: tshirt_red (this is the product name saved in Spirit at the time the product is created)
Product id: tshirt006 (your SKU#)
Product title: [...read more]