Define Report Headers - Intergraph Smart Electrical - Help - Hexagon

This procedure explains how to define the headers in your report template.

1. Select Reports > Edit.

2. On the Edit Report Template dialog, select a report template.

3. Select Open.

4. In the Excel report template, select the cells for the report headers and type the header text in the selected cells.

5. Select another cell for the report header.

6. In the Name Box, type the appropriate name for mapping the report header, for example:

   

   Your report template is based on Excel Macro-Enabled Workbook (*.xlsm), you cannot use the words "BUS" and "PDB" as column names because these words are reserved names in Microsoft Excel. If you need to use these words as headers, we suggest that you add another character or a number to the text, for example BUS1.
   For more details about reserved words in Microsoft Excel, see http://technet.microsoft.com/en-us/library/cc179188(office.12).aspx.

7. Press ENTER.

8. After adding all the required data, save the Excel template.

• To include the properties of a document in your report, add the following macro to the template:

  d_attribute name (For example: d_ItemTag or d_Description)

• You can add plant and plant group column headers to your templates. Use the following macros to show plant and plant group names. Note that all macro names are case-sensitive:

  • Plant.Name

  • Area.Name

  • Unit.Name

  • Unit.<custom property>

• You can use custom properties to add client information.

• For project and contractor information, use the following:

  • Project.<PropertName>

  • Contractor.<PropertName>