Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Hiding columns in a BOM

Status
Not open for further replies.

mrkoko

Mechanical
Aug 3, 2007
40
0
0
CA
Does anyone know of a way to hide columns in a BOM so that they do not appear when printed but do appear when you save the BOM out to an excel or a csv file. I am on SW 2009 sp2

Thanks,
 
Replies continue below

Recommended for you

You can create two copies of BOM Table (one for export and one for printing) and customize them. Next hide/show one of them in FM Tree depending on the situation (printing or exporting)

Artem Taturevich
CSWP
 
ah, thanks ! I really had no idea on that one. A friend though they remember being able to do it with a $PRP$ or something to that effect in the header row of the BOM but I can't find any documents to support that, nor can I get it to work.
 
Can you move the non-printing columns to the right? If so, then set a Print Area (in Excel) for only the desired left-columns.

Otherwise you'll need a macro (actually probably an add-in if you want to use this across many files).

Ken
 
As Artem said previously, just create 2-bom tables. No need to hide either table. For the exported table just drag it off of the drawing sheet and it will not print.

Andrew
 
Status
Not open for further replies.
Back
Top