I have a report where the datasource is a command statement that is connected to a test system. It is an ole db connection that uses integrated security. Also Crystal XI R2
Here’s my question. When I need to move this to production I can’t do it through my normal process of Set Datasource. I guess because it’s integrated security and a command statement. When I try and add the command to the new database, nothing happens.
so the only way that I have found is to create a new command statement to the production database, that then created command_1. I then have to readd all my fields, change everything from Command to command_1
Very tedious and leaves me open for errors.
Please let me know the quick little trick for this.
open the crystal report.try to run the report. It will ask you to enter the connection informtaion like passwodr to the databse. here you can change the database information.
According to support there is no way to change the server that you are connecting to if you are using integrated security. Seems you have to resetup the report when you move it to production.
Go in to Set Datasource Location, click on properties of the connection you wish to change. click twice on datasource. Then allows you to retype the DataSource so you can enter new server, Once you enter that change you will be prompted with connection information allowing you to change the database.
NOTE: This is only an issue if you use integrated security