crystal prob

[EyeTalion]

I have a app that utilizings Crystal Reports. Everything was working fine till we changed our server. I added the new connection to the reports, but everytime I go to run a report it still trys to access the old server...any suggestions?

[Edneeis]

How did you change the connection? Did you change it in the report itself at designtime? Did you change it in the code that runs at runtime? Also make sure you changed it for all of the tables (I'm not sure if this is needed at designtime but it is if the change is on the fly at runtime. Sorry I can't seem to find my project that I had to do this in. I'll keep looking.

Crystal Reports can be a bit of a pain at times huh.

Try this: http://www.experts-exchange.com/Data..._20700347.html

[EyeTalion]

thanks Edneesis...got it working...the first time I went in and changed the source by clicking Database --> Set Datasource Location on the menu bar but that didn't seem to save. Instead I went to Database Fields, opened it up and right clicked on one of the tables then clicked Set Datasource Location..after I changed the server name I got the dialog box that the database has been updated..didn't get that when I went through the menu bar options.

[RichardAtherton]

there is another way, which I have not yet deployed but adopted, it's based around a local host connection:
it uses the report document property connection.info and the applylogoninfo method, to make the report generic.

Unfortunately not tested in deployment, but would appear to provide a solution.