Hello,

We currently have a few items that we private label for some of our customers.  We use the kitted option in inventory to create the item with 1 case of product and 1 label.  All of our item numbers have the same 4 digit number with a alpha label designation (example: 2002CAB, 2002COD, 2002POR, etc.).  The alpha characters tell our warehouse which label to put on the case.

Right now when we run the Unit Sales by Period report, each item is subtotaled separately.  Is there a way in Crystal Reports to run the report that only looks at the first 4 characters when subtotaling?  When tracking sales of the the item, it doesn't matter which label is on the product, rather just how many of that product was sold.  We currently add them up manually, but it would just be easier when doing re-orders to have a report showing all sales of the item regardless of private label.

Thanks,

Rich