If your reports use multiple databases or multiple database user accounts, use this section to enter additional database details. Select a numbered connection, then complete the fields below.
- The Connection and Database values are not required to specify a numbered Username and Password pair when opening a report.
- To automatically match connections found in reports to the correct username and password, also complete the Connection and Database entries.
- The Connection and Database may be used to replace a report’s normal database connection. For example, a report designed using a development database server could use a production database server instead. Similarly, if you had separate databases and/or database servers for different users you could specify which connection to use.
Connection – The connection entered here should exactly match the Data Source Name shown in Crystal Reports under the Database menu, Set Datasource Location. This may be the ODBC DSN name or the database server name.
Database – The database value should usually match the Database value shown in Crystal Reports. The Database value is often used for SQL Server and is typically not used for Oracle databases. You may enter a different Database name if you wish to change which database the report uses when run in ReCrystallize Server.
Username – The database username required for login.
Password – The database password required for login.