Changing database information

You can 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 change the logon name and password of the database and choose to prompt the user for a new 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 Database tab.

   The Database tab appears.

   

3. In Data Source(s) list, select the data source.
4. Update the Logon Name and Password fields as necessary.
5. Select the Prompt the user for new value(s) 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.