Now, mark in BOM sort as 1, 10, 11, 12, ..., 2, 20, 21, ...
I would like sort the number as 1, 2, 3, ... ,19, 20, 21
How do I customize report?
Thanks a lot.
Now, mark in BOM sort as 1, 10, 11, 12, ..., 2, 20, 21, ...
I would like sort the number as 1, 2, 3, ... ,19, 20, 21
How do I customize report?
Thanks a lot.
Thank you Shaodun Lin.
I forgot to tell you that it is BOM in SolidWorks Electrical. I can't sorted item as Numeric.
Is this question answered?
I am facing the same problem - Cannot sort a BOM in solidworks electrical. Please see the attached pdf.
I want to sort the BOM based on the reference number which is listed in the first column.
Hi Saju,
In Electrical go to Project tab > Reports > select the report you wish to sort and select 'Properties' > Navigate to the Sort and Break tab. Make sure that Reference is as high in the list (on the right) as you need it. If Reference is a higher priority to sort by, it should sort the numeric reference correctly as you desire.
Hi Logan
Your comment helped in sorting the BOM based on the reference numbers literally, not numerically. Please see the attached pdf after making the changes that you said. Is there a way to sort the BOM numerically? For eg., I want the reference 79140 as the first row in BOM.
Hi Saju,
Better but not quite there, I agree. Could you please post a picture of your Report configuration 'sort and break' tab?
Report configuration 'sort and break' tab is attached.
Hi Saju,
I'm surprised manufacturer is at the top as the manufacturers didn't seem sorted in order in your previous screenshot.
I would try clicking the 'bom_reference' row and then the up arrow to move it to the top of the list since you want this reference to be the number 1 priority.
Hi Logan
I made a mistake by sending you the screenshot of 'sort and break' of a different project. Please see the attached screenshots. I have 'bom_reference' in the top of the list and still the BOM is sorted 'literally' based on the 'reference'. How do I sort the BOM 'numerically' based on the 'reference' number?
Hi Pongsatorn,
I believe that this is currently an enhancement request: SPR 927144 Ability to have correct numerical sort order in reports, wire lists, etc.. (for example, 1,10,11,12,2,3,4...).
That being said, we might be able to work-around it using some custom SQL code.
Best,
Loretta
order - SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12 - Stack Overflow
^ So far, this is what I've found regarding writing the SQL code...
I got it! All we need to do is change the specific variable for Reference from a varchar to a numeric output. This can be done by modifying the variable in the SELECT DISTINCT section of your report.
Here's an example of how I did it with wire tag:
Sort order before (WIRE NO):
Open report > Activate Expert Mode > Edit > Make the following change:
Sort order after (WIRE NO):
If you would like, I can show you how to do this in your SQL code if you can attach a sample project!
Best,
Loretta
This is very helpful Loretta,
Will be saving this away for future use.
Hi Pongsatorn:
Please refer to SW2015 What's New page 98.
Sorting in a BOM
You can sort items in a BOM literally or numerically.
In a BOM, right-click an item and select Sort. Under Method, select:
Literal
Applies a left-to-right alphanumeric sort to each digit within every field
in the column to be sorted.
Numeric
Applies a numeric sort between numbers based on the magnitude of
the number. When letters are included, alphanumeric sorting is applied
as a secondary sorting method.
For your case, I think it should be sorted as Numeric.
Best Regards
------------------------------------------
Shaodun Lin
Technical Account Manager - APAC, SOLIDWORKS Field Services
------------------------------------------