Add the Reports Server to the Database Reference Codelist

For each Reports Server that you install, you must edit reference codelists in Oracle Clinical to specify the values for the Reports Server.

To set the Reports Server values:

1. Start Oracle Clinical.
2. Navigate to Admin, Reference Codelist, and then Local Codelist to open the Maintain Reference Codelists form.
3. Query for REPORT_SERVER in the Name field.
4. Complete the Short Value and Long Value fields as follows:
   • For each Short Value listed in Table 10-1, enter in the Long Value field the connection string of the Reports Server that you want to use as the default for the specified function.
   • For each additional, non-default Reports Servers, add a row to the reference codelist. Specify a unique name in the Short Value field and the connection string in the Long Value field.

     Table 10-1 REPORT_SERVER Local Reference Codelist Values

     Short Value	Enter in Long Value Field
     REPORT_SERVER	The connection string for the Reports Server you want to use as the default for Oracle Reports.
     JOB_SET_SERVER	The connection string for the Reports Server you want to use as the default for job sets.
     PSUB_SCHEDULER	The connection string for the Reports Server you want to use as the default for PSUB jobs.

5. Click Save.