Changing database information

You can select your database type and set the default database logon information on the Database page for a report. The Database page displays the data source or data sources for your report object and its instances. You can choose to prompt the user for a logon name and password when he or she views a report instance.

To change database settings

1. In the Objects management area of the CMC, select a report object by clicking its link.
2. Click the Process tab, and then click the database link.

   The Database page appears.

   

3. In the Data Source(s) list, select the data source.
4. Select Use original database logon information from the report or Use custom database logon information specified here.

   If you select the first option, you can specify a user name and password to be used with the original report database.

   If you select the second option, you can specify a server name (or a DSN in the case of an ODBC data source), a database name, a user name, and a password for a number of predefined database drivers, or for a custom database driver that you've specified. If you've changed the default table prefix in your database, specify a custom table prefix here.

   The predefined database drivers include: ODBC drivers and native Oracle, DB2, Sybase, and Informix drivers.

5. Select the Prompt the user for database logon when viewing check box if you want users to be prompted for a password when they refresh a report after viewing it once.

   Note:    This option has no effect on a scheduled instance. Also, Crystal Enterprise only prompts users when they first refresh a report; that is, if they refresh the report a second time, they will not be prompted.

6. Click Update.