How to connect to different servers at runtime in Crystal Report

[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

Sudheer

 

[Turkbear]

Hi,
AFAIK, that is not posible - the location of the datasource is static once the report is designed.
If the reason you want to do this is that different data is stored in those locations, then perhaps, if such a feature exists in SqlServer, you could create a link in one location's database to all the other locations and build custom versions of the tables ( in Oracle these would be Views, and be based on a database link) that get their data from the remote site and grant access based on the user's ID to just the correct items for that user.

If, however, you want to do this due to connection speed, etc. I do not know of any solution using just Crystal Reports (no front end)