You are using a web browser or a browser version not supported by this website! This means that some functions may not work as expected.
Use or upgrade/install one of the following browser to take full advantage of this site
Internet Explorer 9 and above
I'm trying to add a "line number" to a BOM report, but I'm having troubles. There doesn't seem to be a way to create a formula that goes 1, 2, 3, 4, etc. Am I missing something obvious?
Categories: SOLIDWORKS Add-Ins, Electrical
Sorry to be the bearer of bad news but SWE does not do item numbers. The expect you to use SW3D for your panel and that is how you get item numbers into your schematic. I had a long discussion with the heads of my VAR about how disappointed I was that something this basic was missing from SWE.
You also cannot export the table to Excel and import it back in directly. I had to go through a multi-step process (using Draftsight) to get this to happen.
I was hoping for some tricky formula hack to make it work
There are no item balloons available either on the panel layouts. I was really disappointed.
I asked the same thing in December and the conclusion was basically, can't be done.
Oh man, YES this can be done, it's not that tricky but I am currently on my phone without access to my computer. Please keep an eye on this thread and I'll have your answer as soon as possible.
Following as well.
Okay, thank you all for your patience as I ran through some various options with mixed results but I think in the grand scheme of things you will like the outcome.
There is an sql command 'ROW_NUMBER' that can be used in the reports to create a variable (integer) based on another variable in your query. So as an example for a cable report I can create a ROW_NUMBER statement based on the cab_tag variable that will produce a result like this:
The query for this is: (Notes: DON'T FORGET to add the comma noted with the red arrow)
Here is a link to a Microsoft article on the ROW_NUMBER statement: ROW_NUMBER
This works well for things like wire and cable reports but I found that if there are multiple select statements you have to switch to the statement DENSE_RANK (LINK).
I had issues getting it to work with the BOM queries provided, but I attribute this more to my skills (or lack of) and time. So here is what I did, I created my own BOM report which I have included in this post as an report archive (I am using SWE 2018) so I have included the archives of my cable, bom and text file for the bom).
Link to archives and text file: DOWNLOAD