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

Comments
Last comment By: Johnathen Lieber   Fri, 01 Jun 2018 17:13:42 GMT
Re: Create Line Number in BOM Report in SWE

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.

By: Robert Hanrahan  Thu, 17 May 2018 13:13:41 GMT
Re: Create Line Number in BOM Report in SWE

I was hoping for some tricky formula hack to make it work

By: Lord Fly  Thu, 17 May 2018 13:18:12 GMT
Re: Create Line Number in BOM Report in SWE

There are no item balloons available either on the panel layouts. I was really disappointed.

By: Robert Hanrahan  Thu, 17 May 2018 13:26:40 GMT
Re: Create Line Number in BOM Report in SWE

I asked the same thing in December and the conclusion was basically, can't be done.

https://forum.solidworks.com/thread/214347

By: Brian Cooke  Thu, 17 May 2018 17:54:27 GMT
Re: Create Line Number in BOM Report in SWE

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.

By: Johnathen Lieber  Tue, 22 May 2018 21:23:59 GMT
Re: Create Line Number in BOM Report in SWE

tenor.gif?itemid=3579864

 

Following!

By: Evan Stanek  Wed, 23 May 2018 13:13:00 GMT
Re: Create Line Number in BOM Report in SWE

Following as well.

By: Matt Shaffer  Tue, 29 May 2018 14:14:34 GMT
Re: Create Line Number in BOM Report in SWE

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:

 

item_cable.png

 

The query for this is: (Notes: DON'T FORGET to add the comma noted with the red arrow)

cable_sql.png

 

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).

 

END Result:

 

bom_report.png

 

SQL Statement:

 

bom_sql.png

 

Link to archives and text file:  DOWNLOAD

By: Johnathen Lieber  Fri, 01 Jun 2018 17:13:42 GMT
You are not authorized to view this page No results found! Suggestions: Check spelling, try a different search, or browse topics below.