I have an inventory report with a subreport.
The subreport tell me who puchased what, the main report groups that by ID then Color. The main report also tells me if I have any unused in inventory
ID
Color Available = 0
George W - 1