Hi,
I am using solidworks electrical for aerospace harnessing. In one project, I will have different harnesses. The report for "bill of materials by harness" is the most useful for me so that I can easily have kits created for each harness assembly. One of the problems with this report is that it seems to include each part as a line item. For example, if I were to add a mil-spec circular connector with 13 crimp contacts, the BOM would have 14 line items with the 13 identical crimp contacts called out as individual lines.
What I want is for the crimp contacts (or any repeated part number / reference) to be grouped as a single line item with a quantity column. Other reports do this, such as the "bill of materials by manufacturer" report. 
The problem with the bill of materials by manufacturer, is that I can't group by harness. The har_tag (harness tag) attribute isn't even included by default for me to add.
It seems like some "expert mode" editing could allow me to add the har_tag attribute to the bill of materials by manufacturer report and allow me to group/break by harness. However I have no idea how to use expert mode and couldn't find much information online.
Does anyone know how to get a report that groups by harness, and also groups together repeated part number/references with quantities?
Thanks,
John
John, you should be able to do this, from what I can see, you just need to check the "Merge rows" option on your column that you don't want repeating, and with the merged rows, add a quantity column with a counter. I'm not sure, does the Harness report have a quantity column? If so, just check that column. If not, Study the BOM report to get the counter working properly, might be a little customized query action, but usually the counter column just needs to be turned on. To do this, you'd go to expert mode, click the "+ column" button, and select the eltcount variable and name that as the counter. It should no appear back in your columns section if you modify the columns shown, it will be one of the options.