To define a SQL value

1. In the Infrastructure Administrator, do one of the following:
   • Click Enterprise and connect to the enterprise industry model. Open a project.
   • Click File and open an industry model drawing or template.
2. Select the Industry Model node for the report.
3. On the Administrator toolbar, click the Report Designer icon .
4. Open a report definition in the Report Designer.
5. Click Add menu > SQL > Manage.
6. In the SQL Manager dialog box, click Add and enter a name for the statement. Click OK.
7. Do one of the following:
   • Enter the statement directly in the SQL area.
   • Click Assistant to start the SQL Assistant to build the statement.
   Example:

   select value from SYMBOL_TBD where id={id_symbol}

   The value {id_symbol} is replaced at runtime by the value of the current record.

8. To add the SQL value to the report, click Add menu > SQL > Name.

   In the report, the value in braces {} is replaced at runtime by the result of the SQL statement.

   Note: You can also add a text control and enter the text {SQL.name}, for example, {SQL.MySQL}.