Can you either add category to the 'all sales report' or total the sales by each category in the salesy by line item category report?
That would allow for easier reporting by line of business.