To create a lookup table using SQR Production Reporting Studio:
Display your report in the Layout window and select Report, then Lookup Tables.
The Lookup Tables dialog box is displayed with any previously-defined lookup tables.
Click Add.
A “lookup wizard” appears with pages where you can enter information about the lookup table.
In the General page, enter information about the lookup table.
Information that you can enter includes:
Sort options—Defines whether the sort will be case sensitive.
Suppress messages during creation—Suppresses the message Loading lookup array... when the command executes. When you select this option, SQR Production Reporting Studio also suppresses the warning message stating the number of duplicate keys found.
Set initial size—The initial size of the lookup table in rows. This is optional and if not specified, SQR Production Reporting Studio uses a value of 100.
Set growth size—The amount to increase the array when it becomes full. This is optional and if not specified, SQR Production Reporting Studio uses 25% of the value defined in the Set initial size field.
Choose the field to use as the key for the Lookup table.
To display the values in the database for a field, select the desired field and click Show Values.
Create a return value by dragging a field into the Return Value edit box (see Lookup Table - Return Value).
To display the values in the database for a field, select the desired field and click Show Values.
If you need several fields returned for each lookup, you can combine more than one column into an expression. You do this by concatenating the columns. The following is an example for Oracle. See your database manual for the correct syntax for your database.
'city||''-''||state||''-''||zip'
Click Finish to return to the Lookup Tables dialog box.