Cost Code Profitability report

SOLVED

Trying to find a way to get a report or create a report in crystal that shows profitability by cost code. It seems every profit type report is by job. I see there's the job cost detail report and you can add the billing amount but it doesn't seem to be tying correctly. Sage 100c Std v2018.