To define a SQL value

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.
Select the Industry Model node for the report.
On the Administrator toolbar, click the Report Designer icon .
Open a report definition in the Report Designer.
Click Add menu > SQL > Manage.
In the SQL Manager dialog box, click Add and enter a name for the statement. Click OK.
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.
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}.