yes, crystal report had LogOnServer method it contains server connection string, so that you can change the sql server location.

In crystal report design time, you can use "logon/off server" and "set location" to change the server location.


Originally posted by mpsudheer
Hi ,

In crystal Report can i be able to connect to different servers based on the user input. Eg- User will select a location (Chennai, Bangalore etc..) based on which i have to connect to SQL Server on that location. I don't have a front end like VB or ASP. I have to do it directly in Crystal Report. Is it possible to do this????

Please suggest a solution

Thanks in advance