OpenUtilities Substation Help

Report Tables

Database report output can either be plots of a design with report information highlighted or report tables.

The Generate Report Table tool is used to generate a report table for each table that has rows attached to elements contained in a fence. A report table contains a row for each row of a particular table attached to an element contained in a fence. Formatting and printing report tables requires report writer software that is available with the relational database package being used.

Since a row is written to the report table for each occurrence of a linked element, the table gives an accurate count of linkages that were attached with Linkage Mode set to Duplicate. Recall that Duplicate linkage mode lets the same row be attached to multiple elements. Linkages that were attached with different linkage modes can even be mixed in the same report table. Thus you may have hundreds of identical items in a design, all with the same row attached, and still generate a report table for inventory control or quantity-takeoffs.

Also note that linkages created with Linkage Mode set to informational will not be reported.

Naming Report Tables

Before a report table can be generated, its name must be specified in the reporttable column of the MSCATALOG table. The name must conform to SQL naming conventions. For example, no symbols or spaces can be contained in the table name.