| Author |
 Topic  |
|
|
rbuck
USA
63 Posts |
 Posted - 01 Aug 2009 : 16:56:22
|
After spending an hour or so I give up. I need to generate a BOM from the schematic that covers the following information:
Part designation Ex: C13
Manufacturer Ex: TDK
Part number Ex: 810-C4532X5R0J107M
Value Ex: 100uF
On the schematic I have added the Part Number, Manufacturer, and Value to the part numbers by right clicking the part and selecting Value and typing in the information.
On the toobar I select Reports and then under User Reports I created one called Complete List. I select that and then select Edit. I then select Component List and click Edit. In the "Columns in Report" window I select Value and click Edit. In the Values: window I select Add and added Value, Part Number, and Manufacturer and clicked OK.
When I run the report I don't get what I need. I don't get anything other than Component, Value, and Quantity. If I modify the Values: window setting and move Part Number to the top of the list, the Part Number replaces the Value when I run the report. None of the part designations show up. Instead of C1, C2, C3, that I want to see, I just get nothing but C for all the capacitors. This type of report is really totally useless.
How can I get all of the information in one report so I can send it to the assembly house?
Ray |
|
|
DavidM
United Kingdom
458 Posts |
Posted - 03 Aug 2009 : 08:58:49
|
Each of the columns in the report produce their values for one component setting. If you Edit the existing 'BOM' report you will see that the 'Columns in Report' list includes Component, Value and Qty.
You would only add multiple names into the Value column if you had some inconsistency in the way values are added to components. For example some Resistors have their value in "R", caps in "C", others in "Value", so you would need to have all three of those 'alternate' names for the Value column. But you would still need separate columns for Part, Mfr, Part Number.
|
 |
|
|
rbuck
USA
63 Posts |
Posted - 03 Aug 2009 : 16:34:56
|
David,
So the question is "How do you add columns to the BOM from the schematic?" That doesn't appear to be an option. If it is, I can't figure out how to add the columns.
If there is a way to add columns, then how do you get the added column values into the part on the schematic?
Ray |
|
|
|
DavidM
United Kingdom
458 Posts |
Posted - 04 Aug 2009 : 12:55:12
|
Ray,
In the 'Columns in the Report' section, click the Add button to the right, this allows you to add a new column to the report and choose what data field you want output in that column.
David |
|
|
|
rbuck
USA
63 Posts |
Posted - 04 Aug 2009 : 21:21:10
|
David,
I don't have an option "Columns in the Report". If I do, I can't find it. Under User Reports, Bill of Materials, the only buttons that are there are New, Copy, Edit, and Rename. None of those allow you to add columns.
Assuming you are able to add columns, how do those column values get added to the actual part in the schematic? This whole report process seems confusing.
Ray |
|
|
|
DavidM
United Kingdom
458 Posts |
Posted - 05 Aug 2009 : 12:26:59
|
Ray,
From the main Reports dialog, select the Bill Of Materials (or your own replacement for it if you've created a new one), and click Edit.
This takes you to a dialog listing the elements of that report. This will show things like
Text 'Bill of Materials'
Blank Line
Standard Report Header
Component List
Now select the Component List, and again click Edit. This gets you to the dialog I was talking about, where you can choose which components should be included in the list, which columns to populate with data from each component, and in what order they should be written.
It is this middle section of the dialog that I was talking about, where you can choose for example to output component position, side, orientation, name, etc, using the Add/Edit buttons to the right of this list of existing columns.
If you choose to output the component field called 'Value', this is the way to access the text items you have got on the Values tab of the Properties of each component in your design.
I hope this makes it clearer!
David
|
|
|
|
rbuck
USA
63 Posts |
Posted - 05 Aug 2009 : 13:30:17
|
David,
Thanks for the clarification. That works and I am able to generate the custom report.
Ray |
|
|
| |
Topic |
|
|
|
Custom Report Setup