How to change datasource in CR XI Server
How can I change the database and server in CR XI server?
For example, my reports is designed against the 'pub1' database and the 'server1' server. How can I change the database to 'pub2' and the server to 'server2' in CR XI server?
I understand within the CR XI Server, there is a place for me to change the datasource.
Under the Database tab in Process Tab, I selected "Use custom database logon information specified here" radio button, and database driver as "ODBC". I entered the server IP, the login and password.
I am using SQL 2000 Server.
I run the report and get Error Message: "Failed to open the connection. C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\crystalreport.reportjobserver\~tmp142c5653066e200.rpt".
I do not understand why failed to open the connection.