I have an SSRS report with data from the WORK_ORDER table. In the table there are four ACT_COST fields, MATERIAL, LABOR, BURDEN, and SERVICE. From what I can tell, these are sums from other tables. I would like to create a drill through to the detail data. I have used the DEMAND_SUPPLY_LINK table to link to REQUIREMENTS and PURCHASE_ORDER tables. I have also queried various tables directly for a couple of customer orders and associated work orders, but I can't get the totals to sum up to the amounts in the WORK_ORDER table. Very frustrating.
I have executed a query to find every table with MATERIAL in a field name, but still have not been able to get my totals to sum up. I am sure it is something simple I am missing, or maybe my original assumption about the WORK_ORDER table is off base. Any help to point me in the right direction is greatly appreciated.
