Define the Layout of a Fixed Format Report Template - Intergraph Smart Electrical - Help - Hexagon

Intergraph Smart Electrical Help

Language
English
Product
Intergraph Smart Electrical
Search by Category
Help
Smart Electrical Version
10

You can edit your fixed format report template in Microsoft Excel and specify how the labels and data are displayed.

  1. Choose a cell on your Microsoft Excel worksheet and type labeling information into it.

    SHARED Tip A label is not a required feature of a fixed format report template. You can simply map properties to cells without any labeling if you want.

  2. Choose a cell where you want the property associated with the labeling to appear.

  3. On the Add-Ins tab of the Excel sheet, select Map Properties and from the menu select the property that you want to map to the cell you chose in the previous step.

    SHARED Tip The properties on the Map Properties menu are specified when you define the contents of your report. For more information, see Define the Contents of Your Report Template.

  4. Repeat the previous steps until you have labeled and mapped all the needed report item properties to the corresponding locations in your template. When you generate a fixed format report, the data for each report item appears in its own worksheet, and the layout for each worksheet matches the layout defined for the first worksheet.

The Options command is not available on the Add-Ins tab for fixed format report templates because you are free to place headers and data anywhere on your worksheet.

Simple Report Template Customization

Simple Report Customization Help

Advanced Report Template Customization

Advanced Report Customization Help