Number One Systems Forum

All Forums

Help For Easy-PC Users

General Issues

BOM with quantities

Author

Topic

Mike Warren

Australia
124 Posts

Posted - 09 Jan 2013 : 11:46:53

Using 16.0.5

I'm sure I was able to do this in the past, but I can't work out how.

What I want is for each unique value to be listed with a quantity. In other words, if I have 5 1K 0805 resistors, I want a list that only has one entry for 1K 0805, but lists a quantity of 5.

Is it possible to do this?

edrees

United Kingdom
779 Posts

Posted - 10 Jan 2013 : 09:25:39

This takes a little more than trial & error with the report settings. Spent hours to date trying to get this right and still not 100% there yet. Best effort so far (save as TestBOM.rtf),-

(ReportTemplate
(Header
(Version 1)
(Context 3)
)
(TEXTBLOCK
(TEXT
(STRING "Bill of Materials")
(NEWLINE TRUE)
(UNDERLINE TRUE)
)
(TEXT
(STRING "")
(NEWLINE TRUE)
(UNDERLINE FALSE)
)
(DESIGNHEADER)
)
(CompList
(SETTINGS
(CSV TRUE)
(CSVQUOTED TRUE)
(CSVSEPARATOR ",")
(HEADERCAPTIONS TRUE)
(HEADERUNDERLINE TRUE)
(KEEPREPEATS FALSE)
(GRANDTOTAL TRUE)
(REVERSEROTATION FALSE)
(SELECTIONMODE 0)
(IGNORESUPPRESSION 0)
)
(COLUMN
(FIELD PARTNAME) (ALIGN LEFT)
(CAPTION "Component")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 30)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD ATTRIBUTE
(NAME "VALUE")
(NAME "R")
(NAME "C")
(NAME "L")
)
(ALIGN LEFT)
(CAPTION "Value")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 20)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD QTY) (ALIGN RIGHT)
(CAPTION "Qty")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM TRUE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD BLANK) (ALIGN LEFT)
(CAPTION "Blank")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 3)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD COMPNAME) (ALIGN LEFT)
(CAPTION "Name")
(COLLATE TRUE)
(COLLATESEPARATOR " ")
(WIDTH 20)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(GROUP
(FIELD PARTNAME)
(ORDER ASCENDING)
(TOGETHER TRUE)
)
(GROUP
(NAME "Value")
(ORDER ASCENDING)
(TOGETHER TRUE)
)
)
)

Mike Warren

Australia
124 Posts

Posted - 10 Jan 2013 : 10:49:07

Excellent! That's exactly what I was looking for. Thank you.

Peter Johnson

United Kingdom
498 Posts

Posted - 21 Jan 2013 : 09:21:37

The main thing that's making this work is that the component reference column (COMPNAME in the template) has the 'Collate' box checked, which allows different component references to be grouped together under the same entry.

Topic