AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

REPORT BUILDER

14 REPLIES 14
Reply
Message 1 of 15
icemansam88
310 Views, 14 Replies

REPORT BUILDER

IS THERE A WAY TO CHANGE THE FORMAT OF THE REPORT BUILDER... I WANT MY BOM TO HAVE UNDER DESC. TO HAVE FIVE SELECTIONS, DESC, QUERY2,QUERY3, MISC1, MISC2 BUT I WANT THEM TO WRAP AROUND INSTEAND OF TAKING UP 5 DIFFERENT LINES OF TEXT.. RIGHT NOW IT LOOKS LIKE THIS:
DESC.
QUERY2
QUERY3
MISC1
MISC2

INSTEAD I WANT IT TO:
DESC., QUERY2, QUERY3, MISC1, MISC2

CAN WE DO THIS?
14 REPLIES 14
Message 2 of 15
Anonymous
in reply to: icemansam88

I think this would have to be done using a custom User Post. There is a
bom.lsp and bom.dcl provided that could be modified to do this. There are
some instructions in the lisp file that might help get you started. If you
need help I might be able to write something that you could modify.

Pat Murnen

wrote in message news:5740716@discussion.autodesk.com...
IS THERE A WAY TO CHANGE THE FORMAT OF THE REPORT BUILDER... I WANT MY BOM
TO HAVE UNDER DESC. TO HAVE FIVE SELECTIONS, DESC, QUERY2,QUERY3, MISC1,
MISC2 BUT I WANT THEM TO WRAP AROUND INSTEAND OF TAKING UP 5 DIFFERENT LINES
OF TEXT.. RIGHT NOW IT LOOKS LIKE THIS:
DESC.
QUERY2
QUERY3
MISC1
MISC2

INSTEAD I WANT IT TO:
DESC., QUERY2, QUERY3, MISC1, MISC2

CAN WE DO THIS?
Message 3 of 15
icemansam88
in reply to: icemansam88

If you could come up with something that would be wonderful we are putting the bom on are drawing and it is taking up to much room the way it is now.
Thank you for the reply and hopefully you can help.
Message 4 of 15
Anonymous
in reply to: icemansam88

What version of AcadE are you using?

Pat Murnen

wrote in message news:5741447@discussion.autodesk.com...
If you could come up with something that would be wonderful we are putting
the bom on are drawing and it is taking up to much room the way it is now.
Thank you for the reply and hopefully you can help.
Message 5 of 15
Anonymous
in reply to: icemansam88

It looks like the user post file is different depending on your choice for
display option, i.e. normal, grouped by Loc/Inst, purchase list, by tag.
Which option are you using?

Pat Murnen

wrote in message news:5741447@discussion.autodesk.com...
If you could come up with something that would be wonderful we are putting
the bom on are drawing and it is taking up to much room the way it is now.
Thank you for the reply and hopefully you can help.
Message 6 of 15
icemansam88
in reply to: icemansam88

Well lets see I am running acade 2008 but am not sure how to check the display options.if you can give me futher instuctions i will get you the information.
Message 7 of 15
Anonymous
in reply to: icemansam88

When you run your bill of materials, what command do you pick from the menu,
schematic or panel bill of materials? If you aren't sure look at the title
bar of the dialog box that comes up. Does it say Schematic Reports or Panel
Reports?

Then on the dialog that comes up in the lower left area there is a group of
radio buttons in a box labelled Display Option with 4 choices,
1) Normal Tallied Format
2) Normal Tallied Format (Grouped by Installation/Location)
3) Display in Tallied Purchase List Format
4) Display in "By Tag" Format

Which of these 4 is selected?

Pat Murnen

wrote in message news:5741469@discussion.autodesk.com...
Well lets see I am running acade 2008 but am not sure how to check the
display options.if you can give me futher instuctions i will get you the
information.
Message 8 of 15
icemansam88
in reply to: icemansam88

First of all its Panel Reports and than its the first botton: Normal Tallied Format....
Message 9 of 15
Anonymous
in reply to: icemansam88

Ok. I will see what I can come up with. I will post something when I can. It
may not be today I am afraid. I am assuming you haven't done any lisp
programming? The user post file for this option is bompnl.lsp and has some
information in it to get you started if you wanted to try on your own.

Pat Murnen

wrote in message news:5741518@discussion.autodesk.com...
First of all its Panel Reports and than its the first botton: Normal Tallied
Format....
Message 10 of 15
icemansam88
in reply to: icemansam88

Pat, I will give it a try but you are correct, I don't have any exp in lisp programming but i am taking a class at au this year in that.... thanks and i do look forward to what ever you come up with...
Message 11 of 15
Anonymous
in reply to: icemansam88

I have attached a zip file with an updated bompnl.lsp and bompnl.dcl. I have
added an option to combine the strings of text in to the DESC field. Back up
the files you currently have and place these in the c:\program
files\autodesk\acade 2008\support folder (this is the default stand-alone
folder they would be installed in).

Basically what I did was take the values in the QUERY2, QUERY3, MISC1, MISC2
and I combine them with the value in the DESC field. So your report needs to
include the DESC field but not all the others.

To use this you would run the Panel Bill of Materials selecting the Normal
Tallied option. When the report is displayed on the Report Generator dialog,
select User Post button. On the dialog that comes up select the 3rd check
box, Combine DESC etc. and OK. Then select the Change Report Foramt and
uncheck all the boxes on the right except for DESC. This is the field that I
placed combined string in. This is so you don't have the values duplicated
on their own lines.

Each time you run this report you would need to select the User Post option
but the Change Report Format field change is remembered.

Let me know if this does what you want.

Pat Murnen

wrote in message news:5741577@discussion.autodesk.com...
Pat, I will give it a try but you are correct, I don't have any exp in lisp
programming but i am taking a class at au this year in that.... thanks and i
do look forward to what ever you come up with...
Message 12 of 15
icemansam88
in reply to: icemansam88

Pat,
I wanted to thank you what you sent me was correct and works fine. I do need your help once again and hope you can tackle this too... I need the unit of measure to show up on my bills of material, like FT, or IN or even EACH. we also are trying to get our wire way and dinrail to show up in either ft or IN. but with little luck. Thanks again for all your help so far.
Sam
Message 13 of 15
Anonymous
in reply to: icemansam88

I would use the Unit value for things like FT, IN, etc. This is entered in
on the Panel Insert/Edit dialog. For Dinrail the Count is per length of
dinrail. It has been logged that it needs to accept a real number so you can
enter in an actual length but I don't think that can be done at this time.
Let me think about a way to get the dinrail length in. Since these are built
dynamically I am not sure you can use the User Defined Attributes to add
this field. Did you search other posts to see if others had dealt with this
laready?

Pat Murnen

wrote in message news:5747925@discussion.autodesk.com...
Pat,
I wanted to thank you what you sent me was correct and works fine. I do need
your help once again and hope you can tackle this too... I need the unit of
measure to show up on my bills of material, like FT, or IN or even EACH. we
also are trying to get our wire way and dinrail to show up in either ft or
IN. but with little luck. Thanks again for all your help so far.
Sam
Message 14 of 15
icemansam88
in reply to: icemansam88

i understand where you input the information like each or feet or inches but how do i get that unit information to show up in the bom report. if i go to change report format there isnt an option to add that to the bom.
Message 15 of 15
Anonymous
in reply to: icemansam88

Sorry. I didn't look at the BOM when I made the suggestion. If the Unit is
an attribute on your symbol, (UM attribute name), then you can include it in
a report by adding it to the list of User-Defined Attributes. On many panel
footprints this data is not held on an attribute though but in xdata added
on-the-fly. You could add this UM as an attribute to the panel footprint
template. This way when the panel footprint is inserted the UM would come in
as an attribute along with any others on the template. The panel templates
are as follows -

wd_ptag_addattr_comp.dwg
component footprints

wd_ptag_addattr_trm.dwg
terminal with terminal number

wd_ptag_addattr_wtrm.dwg
terminal with wire number as terminal number



You can add an attribute to footprints already inserted by using the Add
Attribute tool. But this is done one block at a time.

Right now this is the only way I can think to get this in to the report. I
will log the issue that it is missing from the report. So the 2 steps would
be to get the UM as an attribute on the blocks and then adding UM as a
user-defined attribute (Projects->Reports->User-Defined Attributes). Once it
is added as a user-defined attribute it will show up as an available field
in all reports.

You can use this same idea for the din rail length, add an attribute to the
template and when the din rail is built it is added. But, you would have to
fill the value in yourself. It also would not be totalled up in the BOM but
would just show the individual lengths. This issue has already been logged..

Pat Murnen

..


wrote in message news:5748162@discussion.autodesk.com...
i understand where you input the information like each or feet or inches but
how do i get that unit information to show up in the bom report. if i go to
change report format there isnt an option to add that to the bom.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost