Report Format File Setup Dialog Box - Schematic Missing Bill of Material

Find

 Command entry:  AEFORMATFILE

Select Missing Bill of Material from the Schematic report list.

Category

By default, the report lists schematic components. Select a different Category to run the report for one-line, one-line bus-tap, hydraulic, pneumatic, P&ID, or user-defined components. These components are each identified by a unique WDTYPE attribute value.

Options

Specifies whether to include components, cable markers, connectors, or terminals in the report. You can select one or multiple options to include.

Installation Codes to Extract

Extracts only the information for components with specific installation values. Indicate to process all components, components without an installation code, or only components marked with an installation code that matches that entered in the edit box. Wild-cards are supported.

Once you pick the Named Installation button, you can simply type the installation code in the box or click the List: Drawing or List: Project button to select from a list of used installation codes.

Location Codes to Extract

Extracts only the information for components with specific location values. Indicate to process all components, components without a location code, or only components marked with a location code that matches that entered in the edit box. Wild-cards are supported.

Once you pick the Named Location button, you can simply type the location code in the box or click the List: Drawing or List: Project button to select from a list of used location codes.

Report options

• Save Report to File: Saves the report to a file. Select the type of output file from the Save Report to File dialog box. You can define multiple file outputs using this dialog box. Choose from: ASCII report (.rep), Comma Delimited (.csv), Excel spreadsheet (.xls), Access database (.mdb), and XML (.xml) format.

  The First Section Only button indicates to only show the selected option (such as title line or time and date) on the first section of the report, if multiple sections are used. If not selected, the selected options will be shown on all report sections.

• Change Report Fields: Changes what data fields are reported and the order in which they appear. You can also change the justification of any column and even the column label. The Description field is handled a little differently than the other fields. This field can be a multi-line field which is actually made up of multiple fields. If you include the Description field in your report, you choose which lines make up this field. Just toggle on and off the specific fields to define the Description.
• Put on Drawing: Opens the Table Generation Setup dialog box for specifying how to display your report as a table on your drawing.
• Sort Fields: Controls the sorting order of the fields in the report.
• User Post: Opens the Report Data Post-processing Options dialog box where you specify which options to run when the report is generated.

Note: The options are saved in the format file after you click OK on the subdialog boxes. If you are working in an unnamed format file, you have to save the data after you select Done in order to keep the changes you have made.

Breaks

• Special breaks: Specifies the value that controls the section break. The drop-down list displays the report-specific content to apply to the special break.
• Add Special break values to header: Adds the special break value to the page header. For example, if you select a special break of Installation/Location, the values provided for these devices in the schematic are displayed in the report section header.

Format File

Format files define specific criteria applied to the report before generating the report to screen, printer, file, or automatic generation.

• Open Format File: Selects format files to edit. The Report Format Settings File Selection dialog box opens and displays a list of format files (.set) in the user subdirectory. Select a file to edit from the list and click OK.
• Save Format File: Saves a format file on the hard disk for later retrieval and usage when generating reports.
• Save As Format File: Saves a format file that you opened and modified with a different name.

The default location for format files is \Users\{username}\AppData\Roaming\Autodesk\AutoCAD Electrical {version}\{release}\{country code}\Support\User\.