Show Values and Short Values in a Report - Intergraph Smart Electrical - Help - Hexagon

Intergraph Smart Electrical Help

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

If your report includes select list properties, you can instruct the software to display these properties as they appear under Values in the Data Dictionary, as short text (as defined under Short Values in the Data Dictionary), or both. You can display both definitions in your report and have a column for Values and another column for Short Values if needed.

  1. In Smart Electrical, select Reports > New.

  2. On the New Reports Template dialog, select Blank from the Source template list.

  3. Type a name for the new report.

  4. Select an item type that the report will be based on.

  5. Select a report type and add the report to plant reports if needed.

  6. Select OK and then select Yes when prompted to edit the report.

  7. In Microsoft Excel, select Dedine_Report_Btn on the SmartPlant Reports toolbar.

  8. On the Define Report Contents dialog, select the item type for the new report and select Define.

  9. On the Define Report Item dialog, select the appropriate properties that you want to include in your report. Make sure that you select the properties that belong to the select list type data. (For more details, see steps 9 and 10 of the Define the Contents of Your Report Template procedure.)

  10. Make sure that the Use short text check box is not selected.

    You can also display the index values. To do so, select the Use select list index check box.

  11. Select OK to return to Microsoft Excel.

  12. Define the columns for your report as needed.

  13. If you want to display Short Values in addition to the Values of select list properties in your report, add a new column for the Short Value.

  14. Type the column headers for the Short Values and Values as needed.

    The column header for Value and Short Value can be any text. For example, Long Manufacturer or Short Manufacturer.

  15. For the property column header that will display the Short value, type a name in the Name Box of Microsoft Excel as shown below:

    • ShortValue_[property name]

      For example:
      ShortValue_Manufacturer

  16. Save the report.

  17. To activate this functionality, edit your Excel report.

  18. In the Microsoft Excel, select View and then Macros > View Macros.

  19. On the Macros dialog, select Edit.

  20. At the top of "ThisWorkBook" sheet code, type the following code:

    Public m_objXLAgent As Object

  21. In the BeginReport() function, type the following row:

    Set m_objXLAgent = vParam

  22. In the FinalReport() function, type the following row:

    Call m_objXLAgent.UpdateShortValuesForExcel (me)

  23. Save the report.