Variable Builder

The Variable Builder allows you to add variables that can be used in your report. Variables that you enter in the Variable Builder are written in Production Reporting syntax.

To add a variable:

Enter a name to identify the variable in the Name field at the top of the Variable Builder. Assign a name that will help you identify the variable later. You can enter any alphanumeric character. You cannot enter spaces.
Specify the type of variable you are creating by clicking next to Numeric (see Numeric Variables), String (see String Variables), or Date (see Date Variables).
Enter the variable in the Variable field. To add a variable, you can:
- Drag an operation onto a column in the left pane.
- Drag an operation or column into the Variable field.
- Double-click an operation or column to enter it into the Variable field.
- Type in the variable.
  To delete a variable from the Variable field, click Clear.
  The types of operations that you can use in your variables appear under the Operations pane on the right-hand side of the Variable Builder (for example, numeric functions, file functions, and operators). To view the available options for each type of operation, click the plus sign (+) next to the operation, or double-click the operation.
  Note that you can use the name of a calculated field in your variable. For example, you can create a calculated field, “TotalSalaryByRegion”
```
‘Total Salary is $’||TO_CHAR(#TotalSalaryByRegion) ||’.’
```
Click OK to close the Variable Builder.
If you accessed the Variable Builder by clicking Insert Variable or by selecting Insert, then Variable from the menu, the variable will appear in your report layout.
If you accessed the Variable Builder from the Report Fields dialog box, the variable will appear under the Variables tab. At this point, you can add additional variables, insert the variable into your report layout, or close the Report Fields dialog box
Note:
For more information on the Production Reporting operations that you can use in variables, refer to Volume 2 in the Hyperion SQR Production Reporting Developer's Guide or the Production Reporting Language online help.