2008

Table Of Contents
Generate reports
There is a lot of flexibility with AutoCAD Electrical reports, which can be run
manually or automatically. AutoCAD Electrical extracts multiple fields into
each report type. Different reports contain different fields of information.
When running a report, you can select which fields to include and which
fields to ignore. You can also add your own fields by creating a user-defined
attribute support file (.wda) using the User Defined Attributes List tool. Any
attributes listed in your User Defined Attributes file are added as available
fields to each report. You can strip out some of the field columns of data and
create other useful types of reports. For example, run a component report,
strip out everything except the TAGNAME, DESC1, DESC2, and DESC3 field
columns and you have a legend plate report. If you don't see the specific report
that you need, take advantage of the AutoCAD Electrical flexibility and create
your own.
There are some features that are common to most of the AutoCAD Electrical
reports. You can extract by location or installation values, edit the report,
change the report format, post-process the report with your own programs,
save the report out to a file, print the report, and put the report on your
drawing as a table.
AutoCAD Electrical provides a number of Schematic (page 897)and Panel (page
923)reports. Reports can be formatted from the Report Generator dialog box
or preformatted using Format Files (.set files).
Modify report templates
You can modify Microsoft Excel report templates "wd_template.xls" and
"wd_template_w_macro.xls" so that the report displays the way you need it
to without having to manually modify the report output each time a report
is run. You can change the orientation of a template file to open in Landscape
mode rather than Portrait mode by modifying the template and saving it. Run
a report and save to an Excel file. When the Excel file is opened, it displays
in Landscape mode.
NOTE If you are using the Export Drawing to Spreadsheet tool, modify the
"wd_xls_all_template.txt" template.
TIP Changing some of the setup on template files (such as changing the text in
the first row or the sheet names) can cause the export to fail. Before modifying
any template files, save copies so that you can revert back to the original version
if necessary.
804 | Chapter 14 Reports