Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hiding columns in a BOM

Status
Not open for further replies.

mrkoko

Mechanical
Aug 3, 2007
40
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.

Part and Inventory Search

Sponsor