After you create a lookup table, the next step is to create a variable that uses the lookup table.
To create a lookup variable:
Click
on the Object Toolbar, or select Insert, then Field.In the Report Fields dialog box, select the Variables tab; then, click New and choose Lookup.
If you have not yet created any lookup tables, SQR Production Reporting Studio disables the Lookup option.
In the Lookup Builder, enter information about the lookup table.
Click OK to display the variable in the Report Fields dialog box.
Click Insert to insert the variable into the report layout.