Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. To begin defining the report, select Tools / Database / Report. Then click Create.
    Image Removed Image Added
  2. Enter a report Title and Comments (optional). If you choose Detail, only values from editable fields may be edited before the report is created. With Summary, all values may be edited before printing, even if they come from a non-editable field.
    Image Removed Image Added

    Note: "Object ID" is a unique identifier, and is generated automatically when attaching fields to objects.
  3. The custom fields appear under the "Custom" category. Click the "plus" sign to expand this category.
    Image Removed Image Added
  4. For each field you want to appear in the report, click it under Available Fields, then click the Add button. The field should then appear under Report Fields. Repeat these steps for each of the custom fields.
    Image Removed Image Added
    NOTE
    Note: If you have block in your drawing with attributes you can add those attributes to your report.
  5. Non-custom (standard) fields can also be added to a report. In this example Material is added, and Material is found in the "Common" category.
    Image Removed Image Added
    You do not have to create a report using custom fields; reports may contain only standard fields.
  6. The order of the Report Fields list is the order that will in the report. To change the order, highlight the field you want to move and click Up or Down. (You will also be able to change the order later.)
    Image Removed Image Added
  7. You can use a query if you want to filter the objects to be included in the report. If you want to run a query, click Edit. Otherwise, all objects in the model will be scanned while creating the report.
    Image Removed Image Added
    An example of a query in this example would be to search for objects that have "Part Number" fields greater than one. This is how the syntax would look:
    Image Removed Image Added
  8. If you created a query, click OK to return to the Report Create window.

    Note: For details on query searches, see Select by Query.
  9. Open the Advanced Report table.
    Image Removed Image Added
    The appearance of this tab depends on whether you are creating a Detail or Summary report. For a Detail report, Field Names can be edited. For a Summary report, Report Header Names may be edited.
  10. For the "Copy" row, click the cell in the Function column. From the drop-down menu, select SUM. This will show the total cost of all objects, not the unit price per object.
    Image Removed Image Added
    The other function options are AVG which calculates the average of all values, and MIN / MAX which displays the smallest or largest of the values.
  11. When all fields and queries are defined, click OK to return to the Reports window.
    Image Removed Image Added